Excel formatting question

[Closed]
Report
-
Posts
7098
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
June 10, 2021
-
Hello,
I am trying to figure our how to get the cell to return either a "0" or a blank look when there are no values using the formula in place. This is only happening when I am dividing to cells values to get a new value in that cell. When there is nothing being divided it shows #DIV/0! ....thus I would like to see something other than this while it hasn't been used. can you please help!!!

1 reply

Posts
7098
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
June 10, 2021
487
Hi,
Maybe you can write something like that :

=IF(ISERROR(C2/C3);"";C2/C3)

Best regards