| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
#DIV/0!
I have a formula as follows, m10/m13, cell m10 is
formated to " general " and cell M13 is formated to " currency ".When those cells are 0 and $0.00 respectively the formula returns #DIV/0! Is there a way to have blank cells instead? thank you all Jerie |
|
#2
|
|||
|
|||
|
=if(m13=0,"",m10/m13)
Jerie wrote: I have a formula as follows, m10/m13, cell m10 is formated to " general " and cell M13 is formated to " currency ".When those cells are 0 and $0.00 respectively the formula returns #DIV/0! Is there a way to have blank cells instead? thank you all Jerie -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to sum cells and ignore the #div/0! 's ? | Excel Worksheet Functions | |||
| #DIV/0 ERROR in AVERAGING | Excel Worksheet Functions | |||
| "Average" with error DIV/0 | Excel Discussion (Misc queries) | |||
| #DIV/0 Error | Excel Worksheet Functions | |||
| Trap #Div/0 in conditional formatting | Excel Discussion (Misc queries) | |||
Linear Mode
