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.

=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