Previous Topic Next Topic

Excel formatting question

Closed
Jenbug - Jun 10, 2008 at 11:03 PM
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 - 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 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 491
Jun 11, 2008 at 02:45 AM
Hi,
Maybe you can write something like that :

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

Best regards
0

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Keyboard troubles
jimbobjoe -
car -

38 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses