A Simple Computer Library

IF Application

To compare 2 conditions or more and also can be used to conduct conditional tests on values and formulas.
Please see examples below how if function is used.

This example using single if
To fill up cell C3 the formula is:
=IF(B3=’M',’MARRIED’, “NOT MARRIED’)
To fill up cell F3 the formula is:
=IF(F3>=60,’PASS’, “REMEDIAL’)
..
This example using multiple if

To fill up cell C3 the formula is:
=IF(B3=1,1000,IF(B3=2,2000,IF(B3=3,3000,4000)))
..
The next example is the combination of using IF with AND, OR

To fill up cell C3 the formula is:
=IF(AND(C3>=60,D3>10),”$ 10″,”$ 5″)
To fill up cell C3 the formula is:
=IF(OR(B3>=60,C3>10),”Pen”,”Book”)
Note:
AND (two conditions must be true)
OR (one condition true is still acceptable.

This entry was posted on Friday, July 13th, 2007 at 1:46 pm and is filed under Microsoft Excel. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.