Excel Fundamentals for Data Analysis | Online Course Support

Discounts are calculated as a percentage of the balance owed, rates vary depending on how large the balance is. The lookup table in S2:T5 details what percentage is applied, so for example balances from 300 to 11999.99 get a 5% discount.

 
 
 
 

Similar Posts