a range of numbers?

[t00thless]

hello, i have excel 2000.

heres a breakdown of what i need. ive already written the formula fo
this part. when i enter a number, lets say 600, i want it multiplie
by 1.35. the total, 810, then needs to be broken down into 60, 30, an
10%. like i said, i did all that already.

now, i need a range of numbers from 600 to 4000. all mulitplied by 1.3
then broken down into 60, 30 and 10%. im stumped how do a range lik
that. is it possible? any help is appreciated

 

[Rick Sanderson]

|| hello, i have excel 2000.
||
|| heres a breakdown of what i need. ive already written the formula
|| for this part. when i enter a number, lets say 600, i want it
|| multiplied by 1.35. the total, 810, then needs to be broken down
|| into 60, 30, and 10%. like i said, i did all that already.
||
|| now, i need a range of numbers from 600 to 4000. all mulitplied by
|| 1.35 then broken down into 60, 30 and 10%. im stumped how do a
|| range like that. is it possible? any help is appreciated!
||
||
|| ---
||

If the number you want to calculate is in cell A1 then enter the next number
in the range into A2, select both and then drag the bottom R corner
downwards to complete the required range.
If the formulas doing the calcs are in B1, C1 etc you should also be able to
select these cells and drag them down, normally any necessary changes to the
formula will be made for you.

Regards,
Rick

 

[shades]

In Column A, start with A2, put in 600

A3 601

The select A2 and A3 as noted in previous post and drag down to you
goal.

Then in A1 put 1.35

in B1 put 60%
in C1 30%
in D1 10%

Then in B2 put this formula

=$A1*$A2*B$1

Copy this formula down and across

 

[t00thless]

thank you. wow, that was easy