Answer:
I have created and attached an image with example values for this question.
First we'll learn the IF function syntax:
IF(logical_test, value_if_true, [value_if_false])
Where
logical_test is the decision making comparison
value_if_true is the result to return when TRUE
value_if_false is the result to return when FALSE
We assume that cells B10 to G10 contain the Total Sales for January to June. And cells B17 to G17 contain the Commissions for January to June.
a.
The formula to use in cell B17 is:
<em>=IF(B10>=200000;True;False)</em>
<em />
b.
The formula to use in cell B17 is:
<em>=IF(B10>=200000;B10*0.35;False)</em>
<em />
c.
The formula to use in cell B17 is:
<em>=IF(B10>=200000;B10*0.35;B10*0.27)</em>
<em />
d.
To copy the formula in B17 to C17:G17, you can just copy and paste or select cell B17 and drag from the black square on the bottom right of the cell.
