Math Formulas and Increments

**azexlusr** · 04-07-2010, 02:30 PM

Right. So, here's what I need to do:

I'm developing a pretty specific pricing-related spreadsheet for work. One of the primary functions is to try and calculate a customer discount amount based on a total amount involving increments.

For example, my customer will get a discount of $5 for every $50 they spend. I'd like Excel to calculate that discount based on what my customer spends. If my customer spends $175, then Excel should calculate my customer's discount as $15 (there are 3 increments of $5 in $175).

I hope this makes sense to everyone. Is this even possible in Excel? Anyone? Thank you in advance for your help!!

**Paul** · 04-07-2010, 02:42 PM

Hi Azexlusr, welcome to the forum.

If A10 holds the amount your customer spent, then in another cell use this formula to calculate the discount:

=INT(A10/50)*5

Or, you could subtract that formula from the amount in A10 to get a net total, e.g.

=A10-(INT(A10/50)*5)

Hope that helps!