Microsoft Excel Question :)

[matéo]

Hi I am not familiar with how to use Excel very well so i need your help.

I would like to multiply an entire column by 25% and put the result in another column.

can you give me the formula for that?

please!!!!

thanks times 100!

[Kraig]

Originally Posted by matéo

Hi I am not familiar with how to use Excel very well so i need your help.

I would like to multiply an entire column by 25% and put the result in another column.

can you give me the formula for that?

please!!!!

thanks times 100!

Add the column together first:

1
2
3
4
5
6
=SUM(A1:A6) -- as an example. Substitute the A3:A8 for whatever your column range is.

Then whatever cell that sum formula is in, in the next cell over create another formula and multiply it by 1.25.

So let's say that =SUM(A1:A6) formula is in cell A9 the formula in the next cell over (that will calculate the 25% of what the column is) would be:
=A7*1.25

Get it?

[acidic_liquid]

No :(

[acidic_liquid]

Oh I figured it out. I'm using the Mac version though, I don't know if it's different.

What Kraig said was right. He kinda confused me with his last paragraph though. And I think he meant multiply by 0.25, not 1.25 to get 25% (1.25=125%).

You put down the numbers in a column, say A1 through A9. Then on A10, put the formula that adds it all up (=SUM(A1:A9)). Then, on the column next to that, B10, just copy the formula and multiply it by 0.25 (25%).

Playing around with it is fun :D

[matéo]

thanks Kraig and Erwin.

saved my ass!

[matéo]

WAIT WAIT!


I made a mistake.

I need to take each number in the column and multiply each one by 25%

so the columns have around 50 numbers and I need each one multiplyed by 25% is there a quick way to do this rather then entering every number?

maybe this will help.

its a list of prices of different products each one needs to be listed in another column X 25% and added to the original.

example

if i have 125 in column A I would like to find what the number would be with 25% added.

thnx :)

[charly]

as far as i know, you would have to type them all in manually.

of course you can always copy =A*1.25
and then just add the number of the appropriate cell in after it's pasted. that would make it a bit quicker than completely typing each one in.

[acidic_liquid]

Isn't 16 x 0.25 plus 17 x 0.25 plus 18 x 0.25

the same as

(16+17+18) x 0.25????

If it is, then you'd only have to fix the formula. I really don't know excel. I just figured out the first one from what Kraig said.

But I'm sure there's a way too make a formula for each cell?

I don't know.

What's wrong with doing them all separately on a calculator? :p

I'm really not good at math :( And I don't use excel sorry.

[charly]

Originally Posted by acidic_liquid

Isn't 16 x 0.25 plus 17 x 0.25 plus 18 x 0.25

the same as

(16+17+18) x 0.25????

yes, it is. but by multiplying by 0.25, you're only finding out what 25% of the number is.

it seems he wants to add 25% to each number, therefore you multiply by 1.25.

each cell would also have to have a formula, because each formula would be different due to the cell number.

[matéo]

haha well thanks for the effort erwin. theres 303 of them so typing each one on the caculator and then writing them in the system would take a while.

thnx cheryl.

[filipmaj]

put down the numbers you want to multiply in one column
then put down 0.25 in one column in as many rows as the first column has ie
1 0.25
2 0.25
3 0.25
4 0.25
5 0.25
then copy the first column and "paste special" into the column with the 0.25's. select "multiply" under "operations". and voila!
hope that helped :)

[matéo]

ok ill try it tommorow thnx man!

[pbreak]

NOOOOOOOOO!!!!

These people obviously have their hearts in the right place but i feel you just want something like this...

A B
1 1.0 0.25
2 4.0 1.0
3 5.0 1.25
4 etc.....
5

therefore... in B1 put "=A1*0.25" (do NOT enter quotation marks..)
then just copy B1 and paste it to the rest of the B (or whatever column you are using) and YOU win!! yay.

edit: fucking stupid HTML - those 1.0, 4.0, 5.0 are supposed to be in the "A" column and 0.25, 1.0, 1.25 are supposed to be in the "B" column

[acidic_liquid]

Originally Posted by charly

yes, it is. but by multiplying by 0.25, you're only finding out what 25% of the number is.

it seems he wants to add 25% to each number, therefore you multiply by 1.25.

each cell would also have to have a formula, because each formula would be different due to the cell number.

Yeah I figured that out after *blushes* Like I said, SUCK at math and logic, and excel :(

[Leviathan]

EDIT: What Pbreak said :)


Original Message:
to do this quickly you can just copy and paste the formula

in the first Row 1 Col A you have your first price, In col B you have your first formula which would be =A1*1.25. Highlight the the first formula and copy it (ctrl C). Next, highlight the group of boxes in the column starting below the first formula all the way down to the end of the numbers you have and paste the formula you just copied. Exel will then multiply every number on the left by that formula so row two will be A2*1.25 and row three will automatically be A3*1.25 etc... This is the quickest way of doing it and it only takes two cols.

[matéo]

thanks so much the last example worked no problem!
this saved me many hours!