Previous Topic Next Topic

Excel formatting question

Closed
Jenbug - Jun 10, 2008 at 11:03 PM
aquarelle Posts 7435 Status Moderator - 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!!!
Related:

1 response

Answer 1 / 1
aquarelle Posts 7435 Status Moderator 491
Jun 11, 2008 at 02:45 AM
Hi,
Maybe you can write something like that :

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

Best regards

Similar discussions

My account locked connect to gemail
Karthik -
winko -

2 responses
Keyboard troubles
jimbobjoe -
car -

38 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses