=IF(logical_test,value_if_true,value_if_false)
=if(Put the condition,value if condition is satisfied,Value if Condition is not satisfied)
The "IF" formulla is one of best advance formulla available in excel. The formulla behaves on the logic of If and Than.
Using this formulla user can set a predefined rule that if a value is equal to x than what should be the result and if its not x than what should be the result.
Using above formulla you can always get your basic data work done. We will take a bigger and practical useful example of how to handle various figure using if function.
Student |
Marks(B8) |
Result |
Amar |
45 |
=IF(B8>35,"PASS","FAIL") |
Akbar |
40 |
PASS |
Anthony |
46 |
PASS |
Ram |
80 |
PASS |
Shyam |
33 |
FAIL |
Geeta |
43 |
PASS |
Sheeta |
21 |
FAIL |
Above formulla is a simple case of how by using formulla a lot of time can be saved. One has to just put the formulla and than copy and paste in all other cells.