a) Determine cutoff sales amounts which will decide which category they fall into. These sales amounts must be entered into cells

H5:H7

(highlighted in yellow.)\ b) Determine which bucket each salesperson falls into based on the cutoffs you specified. Do this in column D using the ) function, column E using the

=IFS

( ) function, and column

F

using the =VLOOKUP ( ) function. Note that the results in columns

D,E

and

F

must be identical, for the assumed cutoff levels of sales.

a) Determine cutoff sales amounts which will decide which category they fall into. These sales amounts must be entered into cells H5:H7 (highlighted in yellow.) b) Determine which bucket each salesperson falls into based on the cutoffs you specified. Do this in column D using the =IF ( ) function, column E using the = IFS ( ) function, and column F using the =VLOOKUP()function.NotethattheresultsincolumnsD,EandFmustbe identical, for the assumed cutoff levels of sales