Excel Function : NOT

Download now!

Excel Function : NOT

Category

Logical

Description

Reverses the logic of its argument

Microsoft Excel Reference Page

https://support.office.com/en-us/article/NOT-function-9cfc6011-a054-40c7-a140-cd4ba2d87d77

Syntax and Description of the NOT Excel Function

I have a sheet which contains a lot of values in a table but one of the columns is calculated. The calculation works fine and the formula is copied to the other cells. The problem is that I don't want a formula in the cell I want just the result of the calculation. How can I create a function which can do that for me? The formula is: =IF(B5>=0.01,IF(B5<=0.02,0.1*D5*B5,IF(B5>0.02,0.1*D5*0.02,0)),0) Thank you! A: You can use the

About NOT Excel Function

The NOT function in Excel is used to reverse the logical value of its argument. For example, if a cell contains the logical value TRUE, the NOT function will return the value FALSE.