Enter a formula in cell B10 to return a value of 35000 if the Net Profit After Tax (cell B9)

Question: Enter a formula in cell B10 to return a value of 35000 if the Net Profit After Tax (cell B9) is greater than or equal to 470000 or 100 if it is not

Answer: To formulate this in Excel, the formula used in cell B10 is the IF function is [=IF(B9>=470000, 35000, 100)]

This formula does the following:

1. It verifies whether the value entered in the cell B9 which is Net Profit After Tax is not less than 470000.
2. If this condition is true (i.e.; if B9 is greater or equal to $470,000), it returns 35000.
3. If the condition is false or in other words if the value in B9 is less than 470000 then 100 is returned.

This formula will then calculate and update the right value either 35000 or 100 depending on the Net Profit After Tax value in B9.