Simple % deduciton in excel 2007
 

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

Simple % deduciton in excel 2007
 

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" wrote:

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

Simple % deduciton in excel 2007
 

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

"spudsnruf" wrote in message
...
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

Simple % deduciton in excel 2007
 

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.


"Bernard Liengme" wrote:

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

"spudsnruf" wrote in message
...
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

Simple % deduciton in excel 2007
 

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(SU M(A1*B1)))))))) [as one
example]
--
David Biddulph

"TRYING" wrote in message
...
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.


"Bernard Liengme" wrote:

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

"spudsnruf" wrote in message
...
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

Simple % deduciton in excel 2007
 

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" wrote:

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(SU M(A1*B1)))))))) [as one
example]
--
David Biddulph

"TRYING" wrote in message
...
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.


"Bernard Liengme" wrote:

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

"spudsnruf" wrote in message
...
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

Simple % deduciton in excel 2007
 

Thanks very much. thats done it

"Mike H" wrote:

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" wrote:

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

Simple % deduciton in excel 2007
 

Great. very helpful. cheers

"Bernard Liengme" wrote:

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

"spudsnruf" wrote in message
...
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