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.

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

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

LEARN more :link

=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