How To Use Excel NOT Function

    how to use excel not function

    Quick Intro

    By using Excel Not Function you can reverse a logical value.

    In simple words, It will convert TRUE to FALSE & FALSE To TRUE. If any formula results in a logical value or a cell has a logical value it will reverse that value. In the below example, we have converted logical value TRUE to FALSE by using NOT Function.

     

    Defination for Excel NOT Function

    Syntax

    NOT(logical)

    logical Value you want to test to reverse the logical value.

    Additional Information on Excel NOT Function

    • If you refer to a blank cell it will treat that value as a TRUE.

    Examples

    In the below example, we have used numbers instead of logical values. As you know logical values have values in number.

    You can also use NOT function with numbers as well. As 0 is equal to FALSE, NOT has converted it into TRUE. And, any number other than 0 will be treated as TRUE & converted into FALSE.

    Examples For Excel NOT Function With Numbers

    In the below example, we have used NOT Function with formulas. While comparing values from two cells I have reversed the logical results. You can use this function where you need to reverse the logical value.

    Examples For Excel NOT Function With Formulas

    Sample File

    download sample file to learn more about this tips

    What’s Next?

    To learn more about Excel NOT Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.

    There are also you have OR | AND functions which are highly useful. Apart from this, I have a list of excel functions and some real life formulas examples.