if not function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sarada - 24 Mar 2008 07:03 GMT

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

Reply to this Message

OssieMac - 24 Mar 2008 07:24 GMT

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

Signature

Regards,

OssieMac

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

Reply to this Message

Saran Kumar - 24 Mar 2008 08:37 GMT

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

ur's
saran

> Not function simply reverses the True/false.
>
[quoted text clipped - 7 lines]
>
> > we want to know abou if not function syntax and example.

Reply to this Message

Robert McCurdy - 24 Mar 2008 13:24 GMT

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

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

Reply to this Message