Excel if formulla

VEDANTA DESHIKA (Practice) (317 Points)

01 May 2013  

 

=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.

 

Read full here