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/1672-when-writing-if-statement-what-syntax-%22not-equal.html)

NEEDTOKNOW

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

what is the syntax for writing an If statement for NOT EQUAL TOO

Annie

Use < for not equal to. Example: =IF(A1<32, "error",A1)

"NEEDTOKNOW" wrote:

what is the syntax for writing an If statement for NOT EQUAL TOO

All times are GMT +1. The time now is 10:43 PM.