NOT function

NOT Function

Function Type: Logical

Description:

NOT function Reverses the logic of its argument.
Any FALSE argument will result in TRUE.
Any TRUE argument will result in FALSE.

Logical Operators

Logical test results in a TRUE or FALSE.
Logical tests utilize Logical Operators.

It can also be used together with IF function where we can assign two different results for when it is TRUE and for FALSE.

Function Structure:

=NOT(logical)

Argument Breakdown:

logical – Condition or logical test to be evaluated. This is a boolean that results with either a TRUE or FALSE. This can also be a numerical value. If the given logical argument is a numeric value, zero is treated as logical value FALSE and any other numeric value is treated as the logical value TRUE.

Example:

NOT function samples

Still need help with Excel and Google Sheets? Get Instant Expert Help in Fiverr or PeoplePerHour platforms. Click one icon below.

Get Instant Expert Help on Fiverr

Get Instant Expert Help in PeoplePerHour

We can also accept LEO, HIVE, HBD tokens as payment if we transact directly here in HIVE network.

or you can help me through https://www.buymeacoffee.com/cashheaven 😉


Back to Learn Excel->
*Thumbnail used is made in Canva

Published by Cash Heaven

Excel Expert and Financial Analyst Excel / Google Sheets / Financial Modelling, Valuation and Analysis Effective communicator / High quality / Affordable / Reliable / Quick Turnover I've successfully completed over 200 financial modelling, valuation and analysis projects with start-up stage and corporate companies over the past 4 years. I love to solve problems, have an eye for design, and have built business excel templates. I fix Excel formulas in 10 minutes.

One thought on “NOT function”

Leave a Reply

Discover more from CashHeaven

Subscribe now to keep reading and get access to the full archive.

Continue reading