If list of 10 in J1:j10, use this down thru 5 and 89.99 in the rest
=MAX(LARGE(J:J,ROW()),89.99)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"atoubia" wrote in message
...
I apologize as I am not an excel vet by any means, but any help would be
greatly appreciated.

Here is a brief overview of what I need to figure out a formula for the
following.
I have a spreadsheet to calculate my cell phone rate plans and usage etc.
where I plug in the number of users on a certain plan and it tells me the
total dollar amount. Here is my delima though. There is a new rate plan
that
offers discounts for the first 5 units and then goes back to a set price
for
anything 6 or more.
Here are the prices for each unit.
Unit 1 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!

Thanks,
Andrew