Quantunet.com

My Account

Joins Us
Excel QuickSkills
The NOT() Function Knowledgebase  

 

The NOT() function returns opposite the logical value of it's argument.

  • The syntax for the function is NOT (logical).

Where "logical " represents the logical value of the argument of the function. If the argument has a logical value of TRUE then the NO function will return a logical value of FALSE to the cell. If the argument is FALSE the function returns a logical value of TRUE.

The NOT function can be combined with other logical functions to create new composite functions. For example: NOT( OR (FALSE, FALSE, FALSE)) = TRUE. this in effect a "NOR" function.


How to use the NOT() function:

  • Type " =NOT( "
  • Enter the coordinate of the data cell "A2"
  • Then press the "Enter" or "Tab" key.

 







© 2007 Quantunet LLC All Rights Reserved | Intellectual Property | Terms of Use | Privacy
Home | About Quantunet | FAQ's | Contact Us