#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

 

[Aladin Akyurek]

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

Depending what C37 might house...

a) if just nothing, a non-zero numeric value, or a zero

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

b) if any value is possible...

=IF(ISNUMBER(C37),IF(N(37),D17/C17,""),"")

You could substitute 0 for "" if so desired.

 

[T. Valko]

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

This should suffice:

=IFERROR(D17/C37,"")