It is not-the sum is 10-so Excel continues on to the value-if-false portion of the IF statement which begins with another IF function.Įxcel now checks the sum of C2 and D2 to see if the sum is greater than 7. First, it encounters an IF statement asking if the sum of cells C2 and D2 is greater than 11. Let's look at how Excel processes Team A's formula. If their total score is 12 or greater (> 11), they get a Gold medal. Scores are always integers there are no 'half' points for example. Each team plays two rounds and their scores are added. Now let's study some more useful worksheet examples of nested IF functions. IF(AND(B9>12,B9=18), displayed 'Adult' in the cell, and been done with it. For example, instead of IF(B9>12,'Teen','Child'), they'll write: Helpful Hint: We see many examples on the Internet where the AND function is added to the value-if-false nested IF.
