Excel formatting question

Closed
Jenbug - Jun 10, 2008 at 11:03 PM
aquarelle
Posts
7104
Registration date
Saturday April 7, 2007
Status
Anonymous
Last seen
May 24, 2022
- Jun 11, 2008 at 02:45 AM
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

aquarelle
Posts
7104
Registration date
Saturday April 7, 2007
Status
Anonymous
Last seen
May 24, 2022
490
Jun 11, 2008 at 02:45 AM
Hi,
Maybe you can write something like that :

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

Best regards
0