Simple % deduciton in excel 2007

[spudsnruf]

I'm not sure If I'm going mad or not...but a really simple equation in a
spreadsheet is not working...

My table is, eg, as below

A B C
1 5% 10
2 3% 12

in column C, i just want to get the total of a1 * b1, eg total = 0.5,
I was just assuming i could do @sum(a1*b1)......but that doesnt work

Any help please?

Thank you

 

[Mike H]

Im not certain what your asking but if you want 5% of 10 and 3% 0f 12 then put
this in c1 and drag down

=A1*B1

Mike

 

[Bernard Liengme]

You are very close. Use =A1*B1
SUM is for summing (adding) as in =SUM(A1:A10) to add cells A1+A2+..A9+A10
And formulas begin with = not @ (that was Lotus)
best wishes

 

[TRYING]

Just out of curiosity, I did like spuds did and typed "@sum(A1*B1)" and I
still got .5 in C1. I remembered that was how we did formulas back in Lotus
days. I am using Excel 2007 and neither Transition formula evaluation nor
Transition formula entry was checked in Excel Options/Advanced. Excel
translated the formula I typed to "=SUM(A1*B1)". So it seems to me even
though the word "SUM" and parentheses are unnecessary, they did not hurt
either.

 

[David Biddulph]

There's lot of other things that would not hurt.
If you don't want to stick with =A1*B1, you don't need to satisfy yourself
with =SUM(A1*B1), but you could use
=HARMEAN(MEDIAN(MAX(MIN(GEOMEAN(AVERAGE(PRODUCT(SUM(A1*B1)))))))) [as one
example]

 

[TRYING]

That's a great example, David. I was NOT trying to argue FOR doing more than
necessary. I'm for the simplest, shortest, most efficient solution.

There's lot of other things that would not hurt.
If you don't want to stick with =A1*B1, you don't need to satisfy yourself
with =SUM(A1*B1), but you could use
=HARMEAN(MEDIAN(MAX(MIN(GEOMEAN(AVERAGE(PRODUCT(SUM(A1*B1)))))))) [as one
example]
--
David Biddulph

Just out of curiosity, I did like spuds did and typed "@sum(A1*B1)" and I
still got .5 in C1. I remembered that was how we did formulas back in
Lotus
days. I am using Excel 2007 and neither Transition formula evaluation nor
Transition formula entry was checked in Excel Options/Advanced. Excel
translated the formula I typed to "=SUM(A1*B1)". So it seems to me even
though the word "SUM" and parentheses are unnecessary, they did not hurt
either.

 

[spudsnruf]

Thanks very much. thats done it

Im not certain what your asking but if you want 5% of 10 and 3% 0f 12 then put
this in c1 and drag down

=A1*B1

Mike

 

[spudsnruf]

Great. very helpful. cheers

You are very close. Use =A1*B1
SUM is for summing (adding) as in =SUM(A1:A10) to add cells A1+A2+..A9+A10
And formulas begin with = not @ (that was Lotus)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email