Question

What is nested IF statement in Microsoft excel? Use it to calculate the result of a

class having 10 students.
​

Answer 1

Answer:

One IF function has one test and two possible outcomes, TRUE or FALSE. Nested IF functions, meaning one IF function inside of another, allows you to test multiple criteria and increases the number of possible outcomes. We want to determine a student's grade based on their score.

Explanation:

hope it helps

Answer 2

How to do a nested IF statement in Excel?

Use the IF function, one of the logical functions, to return one value if a condition is true and another value if it's false. For example: =IF(A2>B2,"Over Budget","OK") =IF(A2=B2,B4-A4,"")