Sales Tax Calculations

QuickStove ships worldwide. Howard started working with a small sample of shipments to the western United States. When multiple quantities of an item are in the same order, quantity discounts on that item are offered. Customers are charged sales tax on all shipments within Utah where QuickStove is located as well as on shipments to Oregon where they have another facility. Sales tax is not charged on shipments to other states or contries.

Use IF functions to help Howard calculate approprate sales tax.

Work with IF Functions