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")


--
Regards,

OssieMac


"sarada" wrote:

we want to know abou if not function syntax and example.