formula returning 0 ???

[ajkiwi88]

hi im using the following formulas

=IF(Input!D15="n/a","0",Input!D15) [b8]
=IF(Input!C15="n/a","0",Input!C15) [c8]
=SUM(B8*C8) [d8]
=IF(D8="0","n/a",D8) [e8]

and right at the end i still get a 0 if it started of as n/a and not n/a each cell reference is in square brackets at the end to help you understand it

thanks for any help
cyaz
aj

[swatsp0p]

I think you are confusing "0" with 0. "0" is a text entry, while 0 in the number zero. Your formula is looking for the text entry "0", yet you are receiving a zero as the result of your =SUM(B8*C8). Therefore, "0" does not equal 0 and your formula returns D8 [0] as the result.

Try removing the " " from all references to 0 in your formulas and see if your results meet your needs. e.g.:

=IF(input!D15="n/a",0,input!D15)
=IF(input!C15="n/a",0,input!C15)
=SUM(B8*C8) Note: this can be written as simply =B8*C8
=IF(D8=0,"n/a",D8)


HTH