I have data that looks something like this:

I need an Excel formula that given the dollars on the left would produce the quantities on the right.

It's not a linear regression. The slight curve it has is important.

I just need to generate dummy data along a curve like this. Nothing fancy, and doesn't have to be exact. Ideally, there would be some kind of log or exponent or inversion that I could put into some other cell to change the curve as needed--but the curving is important.

What is some Excel formula that given the value in column A would produce something close to column B?

`LINEST()`

is?`B = A * (21000000 - A) / 20000000000`

2more comments