Ask Question

In cell B17, enter a formula that uses the IF function and tests whether the total sales for January (cell B10) is greater than or equal to 200000.

+5
Answers (1)
  1. 19 January, 22:01
    0
    =IF (B10>=200000,"YES","NO")

    Explanation:

    The following assumptions are made to answer this question

    - If the content of cell B10 is greater than or equal to 200000, cell B17 will return YES

    - If otherwise, cell B17 will return NO

    Having highlighted the above assumptions;

    To start with; an excel formula must begin with an = sign

    Followed by the IF condition

    The content of the IF condition is analyzed as follows:

    B10>=200000: - This is to test if cell B10 is greater than or equal to 200000

    "YES" - > If the above condition is true, cell B17 will display YES

    "NO" - > If otherwise, cell B17 will display NO
Know the Answer?
Not Sure About the Answer?
Find an answer to your question 👍 “In cell B17, enter a formula that uses the IF function and tests whether the total sales for January (cell B10) is greater than or equal to ...” 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