2006-08-31 09:18:22 · 3 answers · asked by Anonymous in Computers & Internet ➔ Other - Computers
This formula will produce a #NULL! result.
=SUM(A1 A2)
That is, no (:) colon between A1 and A2, it must be a space.
A formula that tests for the #NULL! state is:
=ISERROR(A1)
Be sure it is ISERROR, not ISERR.
2006-08-31 18:05:51 · answer #1 · answered by Ken C. 6 · 0⤊ 0⤋
Additional information please. Give an example of what your trying to do.
the following example assumes that the vaule of A2 and A3 are both 10 .
=A2-A3 - Second number subtracted from the first displays 0
=IF(A2-A3=0,"",A2-A3) - Returns a blank cell when the value is zero (blank cell)
=IF(A2-A3=0,"-",A2-A3) Returns a dash when the value is zero (-)
This is how you 'play' with the way a '0' value is displayed. Im assuming the same can be done for '#null'
2006-08-31 09:27:42 · answer #2 · answered by Chuck C 3 · 1⤊ 0⤋
x
2006-08-31 09:23:44 · answer #3 · answered by Anonymous · 0⤊ 0⤋