High School

In cell B28, what formula would return a value of 25,000 if the net profit after tax (B27) is greater than or equal to 250,000, or 1,000 if B27 is less than 250,000?

A. =IF(B27>=250000,25000,1000)
B. =IF(B27<250000,25000,1000)
C. =IF(B27>=250000,250000,1000)
D. =IF(B27<250000,250000,1000)

Answer :

Final answer:

a) =IF(B27>=250000,25000,1000)

The correct Excel formula for the given scenario is =IF(B27>=250000,25000,1000).

Explanation:

The correct formula to return a value of 25,000 if the net profit after tax (B27) is greater than or equal to 250,000, or 1,000 if B27 is less than 250,000 is:

a) =IF(B27>=250000,25000,1000)

This formula utilizes the IF statement in Excel to make the comparison and return the appropriate value based on the condition.

Other Questions