Hello Forum,
I'm new here with a question about a spreadsheet I want to create about the viewers of my website per day.
It's a simple thing, subtracting two numbers, but I don't like the zeros in the empty cells. How can I solve this
MacBook Pro 14″, macOS 14.1
You could create a custom cell format
Create a custom cell format in Numbers on Mac - Apple Support
Set the rule like this, if the value equals 0 it will display an empty cell.
With custom cell format
Without custom cell format
Hope this will help you
Unfortunately it will also show an empty cell if the calculated result is 0, 40-40=0 will display an empty cell!
Ralf
You could create a custom cell format
Create a custom cell format in Numbers on Mac - Apple Support
Set the rule like this, if the value equals 0 it will display an empty cell.
With custom cell format
Without custom cell format
Hope this will help you
Unfortunately it will also show an empty cell if the calculated result is 0, 40-40=0 will display an empty cell!
Ralf
You can also use the IF function to check if one or both cells are empty.
In this example it will only calculate if both cells are not 0
Based on your region the , or the ; will be used to separate the different sections of a formula. If you write one thousand as 1,000.00 then the , is used as your formula separator. If you write one thousand as 1.000,00 then the ; is used as your formula separator.
Hope this will solve your question, please let me know if this worked for you or if something in unclear.
Regards Ralf
zeros in the empty cells.
