View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
spudsnruf spudsnruf is offline
external usenet poster
 
Posts: 46
Default 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