NOT function
Summary
Reverses the logic of its argument
Syntax
NOT(logical)
Example
=NOT(A2>100)
=IF(AND(NOT(A2>1),NOT(A2<100)),A2,"The value is out of range")
=IF(OR(NOT(A3<0),NOT(A3>50)),A3,"The value is out of range")
=IF(AND(NOT(B14<$B$7),NOT(C14<$B$5)),B14*$B$8,0)- IF Total Sales is NOT less than Sales Goal, AND Accounts are NOT less than the Account Goal, then multiply Total Sales by the Commission %, otherwise return 0.
=IF(AND(NOT(A2>1),NOT(A2<100)),A2,"The value is out of range")
=IF(OR(NOT(A3<0),NOT(A3>50)),A3,"The value is out of range")
=IF(AND(NOT(B14<$B$7),NOT(C14<$B$5)),B14*$B$8,0)- IF Total Sales is NOT less than Sales Goal, AND Accounts are NOT less than the Account Goal, then multiply Total Sales by the Commission %, otherwise return 0.