Excel Formula help (percentages)

Ultra_Extreme · 22 Sep 2009 at 14:51

Hey guys, thanks for taking a look. Heres the issue, i want to create a workbook that will give me a percentage in column C of the amount shown in column B. So column B is a list of amounts and in column C i want to generate a number equal to 60% of whatever is in B*. I can do it in individual cells by having the formula B2/100*H1 (where H1 is a rogue cel containing the number 60) but this means i have to manually change B2 to B3 and B4 and so on? Any way i can get the formula to apply to all B column Entries?

TIA

Phage · 22 Sep 2009 at 14:57

I'm not at all sure what you are trying to do here. But a $ sign in front of the B will tie it to that column...and then you can just autofill down the page.

Are you trying to show in Column C a number which is 0.6*B2 ?

Ultra_Extreme · 22 Sep 2009 at 15:03

Phage said:
I'm not at all sure what you are trying to do here. But a $ sign in front of the B will tie it to that column...and then you can just autofill down the page.

Are you trying to show in Column C a number which is 0.6*B2 ?

Yeah i think so lol im trying to get column C to show a number that is 60% of whatever is in the adjacent column. So lets say i put '100' into B2, C2 would then show '60', then if i put 200 into B3 C3 would show '120'and so on down the page

Phage · 22 Sep 2009 at 15:07

Then your formula in C would be =B2*0.6
Then autofill down the page. This can be done either by dragging the 'handle' on the bottom right hand corner of the formula cell to the bottom of the column, or, if you have already filled column B with data, just double-click the handle.

Or am I missing something ?

Ultra_Extreme · 22 Sep 2009 at 15:24

Phage said:
Then your formula in C would be =B2*0.6
Then autofill down the page. This can be done either by dragging the 'handle' on the bottom right hand corner of the formula cell to the bottom of the column, or, if you have already filled column B with data, just double-click the handle.

Or am I missing something ?

Perfect m8 thanks a lot didnt realise you could just drag the formula along like that, dead easy! Anyway cheers!

Namsnik · 22 Sep 2009 at 21:31

Or if you want to vary the percentage by changing H1 you could use =B2*$h$1 fill down as Phage advised