Need Excel Guru help asap!

[Negative Decibel]

So, I have a simple 2 column worksheet for prices of number of licences:

Column A is the number of licences, and Column B has prices. Simple.

Column A starts at 1, and goes to 10,000. The prices in Column B start at $37.46 and gradually go down to $9 (around line 2100 or so. and yeah the rest from 2100-10000 is only $9.

Here's what I'm trying to do. They want new prices that are lower, but end about the same @ $9. The first cell in Column C is B3*.73, or $27.35...

It seems so simple, but I'm having a hard time on this one.

 

[Snowknight26]

Can you clarify what you're trying to accomplish?

 

[Negative Decibel]

yes. I want new lower prices. with the first price exactly 73% of the cost of one licence, and the price to gradually go down to a minimum of $9.

This is what the graph looks like now.

this is what the end result should look like:

basically I'm shifting the graph down, but compressing it so the lowest price does not go below $9.

 

[Negative Decibel]

never mind. figured it out had to use EXP() function.. and such.