Use an if function in cell h18 to calculate the commission


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!!
Operation Management: Use an if function in cell h18 to calculate the commission
Reference No:- TGS01139476

Expected delivery within 24 Hours