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

+2
Answers (1)
  1. 19 December, 16:31
    0
    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.
Know the Answer?
Not Sure About the Answer?
Find an answer to your 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 1000 if ...” in 📗 Computers & Technology if the answers seem to be not correct or there’s no answer. Try a smart search to find answers to similar questions.
Search for Other Answers