#DIV/0 Issue

[gmazza76]

Good Morning,

Is there anyway i can write ISSNA into the following sum as i havent come across it before i just now ISSNA can be used to stop the error #DIV/0 showing up.

=IF(C37="","",D17/C37)

The sum works on some lines but not on others.

Many Thanks
Gavin

 

[VoG]

Maybe this

=IF(ISNUMBER(C37),D17/C37,"")

 

[p45cal]

Version of Excel?

 

[Michael M]

=if(isna(c37="","",d17/c37),"",(c37="","",d17/c37))

 

[p45cal]

Excel pre-2007:
=IF(ISERR(D17/C37),"",IF(C37="","",D17/C3))

later versions:
=iferror(IF(C37="","",D17/C37),"")

ISNA won't detect #DIV/0!

 

[Michael M]

P45cal
Yep, you're right....and a bottle of Chardy won't iprove your Excel skills....

or your spelling

iprove

 

[p45cal]

P45cal
Yep, you're right....and a bottle of Chardy won't iprove your Excel skills....

or your spelling

iprove??!!
Did I type that? (I haven't edited anything since you posted this)

 

[bosco_yip]

Or......

=IF(OR(C37=0,C37=""),"",D17/C37)

Regards

 

[Michael M]

No....I did !!

maybe should have read.....MY spelling !!

 

[aiwnjoo]

Conditional Formatting, if you have many formulas leading to other cells also with formulas depending on other cells you will find that you will be better to use conditional formatting with this;

=ISERROR(CELL)