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

Statement to be written in cell B10:

IF (B9 > = 470000, 35000, 1000)

Formula:

IF (logical_test, [value_if_true], [value_if_false])

Explanation:

logical_test = Net Profit After Tax (cell B9) value_if_true = 35000

(if the Net Profit After Tax (cell B9) is greater than or equal to 47000)

3. value_if_false = 1000

(if the Net Profit After Tax (cell B9) is lesser than 47000)

Each value should be separated by comma.