*How to use "IF" function with "And / Or / Not" functions in excel*
__IF Function In Excel__

*=IF(C4>=$C$1,"Allow","Not Allow")*
*In this Example picture defines us to when salesperson Achieved target to Allow Bonus Otherwise Not Allow. if c4 cell value is 460,027 and target value is 500,000 in cell c1. if c4 greater than or equal to c1 result True if the value is true if a function is shown result "Allow" if the value is false shown result "Not Allow"*

**And Function In Excel With IF Function**

*=IF(AND(C15>=$C$11,D15>$C$12),"Allow","Not Allow")*
*in the picture use "AND" function. "AND" function is very useful logical_test Function in Excel. In this function all arguments evaluate is true result is True. One and more than one arguments evaluate is false result is False.*

*=And(Logical1, Logical2....)*
*=And(True, True, True) = "True"*
*=And(True,True,False) = "False" *
**Or Function In Excel with If Function**
*=IF(OR(C25>=$C$21,D25>$C$22),"Allow","Not Allow") *

*in the picture use "OR" function. "OR" function is very useful logical_test Function in Excel. In this function one and more than one arguments evaluate is True result is True.*

*=Or(Logical1, Logical2....)*
*=Or(True, True, True) = "True"*
*=Or(True,True,False) = "True" *
*=Or(False,False,False) = "False"*
__Not Function Use With if Conditions__
*=IF(NOT(AND(C35>=$C$31,D35>$C$32)),"Not Allow","Allow") *

*In the picture use "NOT" Function. "NOT" Function Reverses your Result. that mean True Value convert in False and False value convert in True. Not function use when you want to make sure a value is not equal to one particular value.*

*Video*

* *