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 350000 or 1000 if it is not.

Answer 1

To provide the desired functionality in Excel, use the formula =IF(B9>=350000, 35000, 1000) in cell B10, which applies an IF statement to determine if cell B9 is greater than or equal to 350000.

Step-by-step explanation:

To return a value of 35000 if the Net Profit After Tax (cell B9) is greater than or equal to 350000, or 1000 if it is not, you should enter the following formula into cell B10:

=IF(B9>=350000, 35000, 1000)

This formula uses the IF function in Excel. The function checks whether the condition (B9>=350000) is met. If the condition is true, it returns 35000; otherwise, it returns 1000.