Question: Can I evaluate multiple conditions in a formula?
Answer: Yes, with the Nested If Statement
Why: In order to construct more elaborate tests of the data
Process (Excel 2003, 2007 and 2010):
The If statement can be used to conduct conditional tests on values and formulas. However if more elaborate testing of data will be carried out then the Nested If Statement can be used.
1. To calculate the trade discount percentage for clients based on the table below;
|
TOTAL PURCHASES |
DISCOUNT PERCENTAGE |
|
>=$30,000 |
7% |
|
>=$20,000 |
5% |
|
>=$10,000 |
3% |
|
<$10,000 |
0% |
2. Enter the data given below
3. Select cell D2 and type the following formula; =IF(C2>=30000,”7%”,IF(C2>=20000,”5%”,IF(C2>=10000,”3%”,”0%”)))
4. Press enter and copy the formula down
5. The result will be as below
