Nested if statement
1 / 9

Nested IF Statement - PowerPoint PPT Presentation

  • Uploaded on

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.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about 'Nested IF Statement' - jerod

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

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

  • A basic IF function is of the form below. IF AND. Today’s lesson we will learn about Nested IF.

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

Task IF AND. Today’s lesson we will learn about Nested IF.

  • Lets look an example of a class result data to learn more about nested if

  • Replicate the data as in the picture

  • 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")))

Self assessment
Self Assessment following scenario:

  • 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

Conditional formatting
Conditional formatting following scenario:

  • Follow the below link which shows many examples on how to use conditional formatting.

  • After that follow the task given on the next slide.

Conditional formatting1
Conditional Formatting following scenario:

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

E xtension
E following scenario:xtension

  • 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