Simple % deduciton in excel 2007

S

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
 
M

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
 
B

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
 
T

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.
 
D

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]
 
T

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.


David Biddulph said:
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

TRYING said:
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.
Click to expand...
Click to expand...
 
S

spudsnruf

Thanks very much. thats done it

Mike H said:
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
Click to expand...
 
S

spudsnruf

Great. very helpful. cheers

Bernard Liengme said:
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
Click to expand...
 
Top