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.

Answer 1

Answer:

=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

Answer 2

The conditional statement, IF to check if total sales is less than or equal to 200000 is =IF(B10 >= 200000, 'TRUE', 'FALSE')

• The IF statement in excel is used to check a given condition and a preferred output is given if the condition hold true and another output if otherwise.

• Excel formulas begin with the equal to sign ; =

• The statement above checks through each values in cell B10; if the value is greater than or equal to 200000

• For cells with values greater than or equal to 200,000 display TRUE in the corresponding cell ; otherwise display FALSE.

Therefore, the required statement to be entered on cell B17 is =IF(B10 >= 200000, 'TRUE', 'FALSE')

LEARN more :https://brainly.com/question/15658815