Not quite, all I need is for the first 5 to be different values and then
anything 6 or more to be one set value and then have them add them all
together.

"Pete_UK" wrote:

Take a look at this link:

http://www.mcgimpsey.com/excel/variablerate.html

I think it is what you are trying to describe - if not, post back.

Hope this helps.

Pete

On Jan 13, 4:07 pm, atoubia wrote:
Here is a brief overview of what I'm trying to do. I need to find a grand a
sum, but here is the thing. There is a discount for the first 5 units, so
unit one is 99.99 unit 2 94.99 unit 3 89.99 unit 4 84.99 unit 5 79.99 but
then anything 6 or above goes back to 89.99 so for example if I have a total
of 9 it would look like this

1. 99.99
2. 94.99
3. 89.99
4. 84.99
5. 79.99
6. 89.99
7. 89.99
8. 89.99
9. 89.99

For a total of 809.91 I just dont how to put this into a formula format. Any
help would be greatly appreciated!