IF Condition In Excel (>) (<) (=) (>=) (<=)

IF condition is used when you want to find the particular value or data on the basis of your requirement. For Ex:- Greater than ( > ) Less than ( < ) Equal To ( = ) Greater Than and Equal To ( >=) Less Than Equal To ( <= ) and many more… So if condition plays a vital role when you want to find the data on Basis of matching condition. If the condition match then the output should be this and that. 🙂

PARAMETER : ( Logical Test, Value If True. Value If False )

USE: IF ( Cell Value > Some Amount or Less than or Equal to , Yes , NO )

Formula Ex: =IF ( B2 > 500,”Yes”,”No”) / =IF ( A3 < 500,”Yes”,”No” ) / =IF ( A4 >= 500,”Yes”,”No” ) / =IF ( A5 <= 500,”Yes”,”No” )