if not function
 

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

if not function
 

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.

if not function
 

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

ur's
saran

"OssieMac" wrote:

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.

if not function
 

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
"sarada" wrote in message
...
we want to know abou if not function syntax and example.