| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 crashing with simple scatter plots with 8 k data points | Charts and Charting in Excel | |||
| Simple links in Excel 2007 | Excel Worksheet Functions | |||
| Simple problem, simple formula, no FUNCTION ! | Excel Worksheet Functions | |||
| Simple way to enable just my personal macros in Excel (& Office) 2007 | New Users to Excel | |||
| Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
Linear Mode
