Help with 'simple' formula

's Computer Specifications

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

's Computer Specifications

A2: = A1*1.5

etc.

--

HTH

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

"Brian" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
>

's Computer Specifications

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.
--
Earl Kiosterud
www.smokeylake.com

"Brian" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>

's Computer Specifications

Thanks, that works precisely.

"Earl Kiosterud" <(E-Mail Removed)> wrote in message
news:%23fQyB%(E-Mail Removed)...
> 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.
> --
> Earl Kiosterud
> www.smokeylake.com
>
> "Brian" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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
>>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
is there a simple formula that will remove all duplicates in a simple list	john	Microsoft Excel Misc	1	19th Nov 2010 10:32 AM
IF formula-simple question; simple operator	Rich D	Microsoft Excel Misc	4	6th Dec 2007 04:36 PM
Simple problem, simple formula, no FUNCTION !	=?Utf-8?B?Um9uQEJ1eQ==?=	Microsoft Excel Worksheet Functions	6	28th Sep 2007 05:51 PM
Simple Formula for simple person. :)	John	Microsoft Excel Discussion	1	5th May 2004 05:55 AM
simple? pasting simple formula, error on copy	sns	Microsoft Excel Discussion	4	11th Jan 2004 01:22 AM