we want to know abou if not function syntax and example.
O OssieMac Mar 24, 2008 #2 Not function simply reverses the True/false. Example of a simple If function to test for Zero:- =IF(A1=0,"Is Zero","Not Zero") Nesting the above with the Not function as follows:- =IF(NOT(A1=0),"Not Zero","Is Zero")
Not function simply reverses the True/false. Example of a simple If function to test for Zero:- =IF(A1=0,"Is Zero","Not Zero") Nesting the above with the Not function as follows:- =IF(NOT(A1=0),"Not Zero","Is Zero")
R Robert McCurdy Mar 24, 2008 #4 Also you can use <> An example: =A2<>"Dog" If A2 has 'Dog' then the formula returns FALSE otherwise it returns TRUE. <> stands for Not Equal Regards Robert McCurdy
Also you can use <> An example: =A2<>"Dog" If A2 has 'Dog' then the formula returns FALSE otherwise it returns TRUE. <> stands for Not Equal Regards Robert McCurdy
