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.
