If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
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 |
#8
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|