The commission rate is 2 for all sales that total more than


Use an IF function in cell H18 to calculate the commission rate for the total sale for order 1.

The commission rate is 2% for all sales that total more than $10 and 1% for all sales that total more than $5. No commission is paid on sales that total $5 or less.

Reference the threshold levels (cells F13 and F14) in your logical tests for your IF function and the commission rates (cells G13 and G14) as your "value_if_true" and "value_if_false" arguments.

Use appropriate relative and absolute references.

Request for Solution File

Ask an Expert for Answer!!
Financial Management: The commission rate is 2 for all sales that total more than
Reference No:- TGS02629987

Expected delivery within 24 Hours