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!

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!

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!

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

On Jan 13, 5:31*pm, atoubia wrote:
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.