Hi all. I am trying to create data showing an exponential decline in the values. I have the first and last values and need to populate everything in between.
For example, Column A lists values (1 through 10,000). Each value in column B decreases exponentially in relation to Column A's value. The first (1) value is 100 and the 10,000 value is 1.
I need a formula to fill in the blanks in between. The only thing I could find was the formula y = ae<SUP>bx </SUP>but cannot figure out how to incorporate this formula effectively into my sheet.
Anyone, please help!!
For example, Column A lists values (1 through 10,000). Each value in column B decreases exponentially in relation to Column A's value. The first (1) value is 100 and the 10,000 value is 1.
I need a formula to fill in the blanks in between. The only thing I could find was the formula y = ae<SUP>bx </SUP>but cannot figure out how to incorporate this formula effectively into my sheet.
Anyone, please help!!
