Nested IF Statement. Last week we looked at IF statements and looked at IF OR and IF AND. Today’s lesson we will learn about Nested IF.
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
=IF(condition, value if true, value if false)
=IF(condition1, value1 if true, IF(condition2, value2 if true, value2 if false))
If the percentage is 80 or higher but less than 90, the student will receive a B.
If the percentage is 70 or higher but less than 80, the student will receive a C.
All other students will receive an F.
=IF(B2>=90, "A", IF(B2>=80, "B", IF(B2>=70, "C","F")))
1. Formatting: eg integer, real ,date, currency, text; styling eg bold, italics, borders, shading, column alignment
Excel has good features to compliment the IF statements that we had produced earlier on.