when writing an IF statement what is the syntax for "Not Equal to.

NEEDTOKNOW · Dec 10, 2004

If statement for greater than would be =IF(B12>0,B12)

What would it be for NOT EQUAL to ?

JE McGimpsey · Dec 10, 2004

one way:

=IF(B12<>0,B12)

which will return FALSE if B12 = 0