1 / 9

Nested IF Statement

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.

jerod
Download Presentation

Nested IF Statement

An Image/Link below is provided (as is) to download presentation 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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Nested IF Statement

  2. Last week we looked at IF statements and looked at IF OR and IF AND. Today’s lesson we will learn about Nested IF. • A nested IF function is a statement that contains at least one IF function inside another. That is, a nested IF function contains another IF statement as one (or both) of the true/false values. In this manner, the original IF function checks for a condition and, depending on the result of that check, it may go on to check another condition.

  3. A basic IF function is of the form below. =IF(condition, value if true, value if false) • On the other hand, nested IF functions can take on a variety of different appearances, depending on how complex the nesting sequence is. One example is shown below. =IF(condition1, value1 if true, IF(condition2, value2 if true, value2 if false))

  4. Task • Lets look an example of a class result data to learn more about nested if • Replicate the data as in the picture

  5. Looking at the formula for nested if try it for the following scenario: • If the percentage correct is 90 or higher, the student will receive an A. 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")))

  6. Self Assessment • To do the assignments we get in the future we need to make sure we know the below. Therefore do a checklist of the below and if in doubt check the teach-ict website videos to learn about specific topics. 1. Formatting: eg integer, real ,date, currency, text; styling eg bold, italics, borders, shading, column alignment

  7. Conditional formatting • Follow the below link which shows many examples on how to use conditional formatting. http://www.free-training-tutorial.com/conditional-formatting.html • After that follow the task given on the next slide.

  8. Conditional Formatting Excel has good features to compliment the IF statements that we had produced earlier on. • Download the conditional formatting.xlsx file from the website. • Follow instruction given within

  9. Extension • Get into groups of 3-4 and research how to add additional worksheets within excel and and how to link them. • For example in work sheet 1 the user enters 2 numbers in 2 different cells. In worksheet 2, in a given cell, the sum of the two numbers is shown

More Related