Help with 'simple' formula

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

Howdy All,

I'm having a brainfart.

I need to write a formula to calculate the following:

base number = 12
for every increase in quantity over 1, i need the base number to increase
50% from the previous level

results would be

qty 1=12
qty 2=18
qty 3=27
qty 4=40.5
etc.

Thanks,
Brian
 
A2: = A1*1.5

etc.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Brian,

If B2 contains the quantity, then use:

=12*1.5^(B2-1)

I've hardcoded the base number, poor programming practice. But this shows
how it works.
 
Thanks, that works precisely.


Earl Kiosterud said:
Brian,

If B2 contains the quantity, then use:

=12*1.5^(B2-1)

I've hardcoded the base number, poor programming practice. But this shows
how it works.
Click to expand...
 
Back
Top