Question

In cell C5, enter a formula using the IFS function that returns a value of P1 if cell B5 is greater than 50,000,a value of P2 if cell B5 is greater than 25,000, and a value of P3 for all other results.

Answer 1

The formula using the IFS function would be =IFS(B5>50000,"P1",B5>25000,"P2",TRUE,"P3")

How does the formula work?

The first argument, B5>50000, checks if the value in cell B5 is greater than 50,000. If it is, the formula returns P1.

The second argument, B5>25000, checks if the value in cell B5 is greater than 25,000. If it is, and the first condition is not met (B5 is not greater than 50,000), the formula returns P2.

The third argument, TRUE, is always true, ensuring that the formula always evaluates to one of the three values: P1, P2, or P3.

The fourth argument, P3, is the value returned if none of the previous conditions are true (B5 is not greater than 50,000 or 25,000).