#### Freq_Flyer

##### New Member

- Joined
- Jan 27, 2009

- Messages
- 3

My first post to this forum. thank you everyone who answers these questions.

I need an Excel formula that computes a discount such that:

f(1) = 10 f(2) = 20 f(3) = 30 f(4) = 40 f(5) = 40

f(6) = 50 f(7) = 60 f(8) = 70 f(9) = 80 f(10) = 80

f(11) = 90 f(12) = 100 f(13) = 110 f(14) = 120 f(15) = 120 etc.

Essentially, the formula is f(x) = 10x, but it 'discounts' every x divisible by 5.

Any input would be greatly appreciated

Dan