Excel formatting question
Closed
Jenbug
-
Jun 10, 2008 at 11:03 PM
aquarelle Posts 7141 Registration date Saturday April 7, 2007 Status Moderator Last seen December 19, 2024 - Jun 11, 2008 at 02:45 AM
aquarelle Posts 7141 Registration date Saturday April 7, 2007 Status Moderator Last seen December 19, 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!!!
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:
- Excel formatting question
- Excel mod apk for pc - Download - Spreadsheets
- Marksheet format in excel - Guide
- How to change date format in excel - Guide
- How to clear formatting in excel - Guide
- Number to words in excel - Guide
1 response
aquarelle
Posts
7141
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
December 19, 2024
491
Jun 11, 2008 at 02:45 AM
Jun 11, 2008 at 02:45 AM
Hi,
Maybe you can write something like that :
=IF(ISERROR(C2/C3);"";C2/C3)
Best regards
Maybe you can write something like that :
=IF(ISERROR(C2/C3);"";C2/C3)
Best regards
