Need to add different vaules based on qauntity, is this possible?

[atoubia]

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!

 

[Pete_UK]

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

 

[atoubia]

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]

Well, I didn't quite understand your first description. Presumably
those numbers were meant to be percentages?

Please describe what data you have, how it is laid out in your
workbook, and what you want to achieve with some example data.

Pete