if not function

[sarada]

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

 

[OssieMac]

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

 

[Saran Kumar]

thank you yaar................ nice information

ur's
saran