if not function

O

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function needed to search and pull data from 1 table to another 4
Excel - Wich Function should I use? 1
If then Statement for Excel Columns 2
Incorporating the User Profile location into a document template path 1
How to count Conversations in Outlook 2013 0
Sheet Selection 7
Over time? 4
Query regarding any lookup function 3

Top