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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - when writing an IF statement what is the syntax for "Not Equal to. (https://www.excelbanter.com/excel-discussion-misc-queries/1673-when-writing-if-statement-what-syntax-%22not-equal.html)

NEEDTOKNOW

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

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

What would it be for NOT EQUAL to ?

JE McGimpsey

one way:

=IF(B12<0,B12)

which will return FALSE if B12 = 0

In article ,
"NEEDTOKNOW" wrote:

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

What would it be for NOT EQUAL to ?

All times are GMT +1. The time now is 06:50 AM.