Ask Question
8 November, 00:43

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.

+4
Answers (1)
  1. 8 November, 01:39
    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?
Get 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 there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers