How do I tell excel to add the above cells and multiply?

[eldorado99]

Die! Wrong forum nazis! bang bang bang!

Anyway in Excel, how do I tell it to add the above cells and multiply by 0.7? I have it set to =SUM(above) right now which I'm assuming adds the above cells, but if I add PRODUCT(0.7) it gives me a syntax error? dubya tee eff?

 

[Soccer55]

=SUM(startcell:endcell)*0.7

-Tom

 

[imported_LoKe]

=SUM(above) * 0.7?

 

[godmare]

Originally posted by: eldorado99
Die! Wrong forum nazis! bang bang bang!

wrong forum

 

[eldorado99]

And now how do I make it update this box constantly with the correct number as I enter fields, instead of having to tell it the formula every time i need the total?

 

[dethman]

Originally posted by: eldorado99
And now how do I make it update this box constantly with the correct number as I enter fields, instead of having to tell it the formula every time i need the total?

it does it automatically. take an excel class.

 

[Orsorum]

Originally posted by: eldorado99
And now how do I make it update this box constantly with the correct number as I enter fields, instead of having to tell it the formula every time i need the total?

Mind giving us a sample spreadsheet?

 

[eldorado99]

Originally posted by: dethman

Originally posted by: eldorado99
And now how do I make it update this box constantly with the correct number as I enter fields, instead of having to tell it the formula every time i need the total?

it does it automatically. take an excel class.

No it doesnt seem to, I guess I should specify that this is actually a table in word not in excel .

 

[dquan97]

Originally posted by: eldorado99

Originally posted by: dethman

Originally posted by: eldorado99
And now how do I make it update this box constantly with the correct number as I enter fields, instead of having to tell it the formula every time i need the total?

it does it automatically. take an excel class.

No it doesnt seem to, I guess I should specify that this is actually a table in word not in excel .

calculate it in excel first, then copy/paste to Word

 

[eldorado99]

Originally posted by: Orsorum

Originally posted by: eldorado99
And now how do I make it update this box constantly with the correct number as I enter fields, instead of having to tell it the formula every time i need the total?

Mind giving us a sample spreadsheet?

I dont know how to give you a sample, but its a column of numbers, and at the bottom I need a column to give me the percentage of the total of those numbers (70%) and so now I have the formula, but it only works when I enter the formula and I need to constantly update and for the formula to stay in action constantly rather than working once when I enter it.

 

[imported_LoKe]

You expect the Excel effect in Word? They're not the same program for a reason.

 

[eldorado99]

Originally posted by: dquan97

Originally posted by: eldorado99

Originally posted by: dethman

Originally posted by: eldorado99
And now how do I make it update this box constantly with the correct number as I enter fields, instead of having to tell it the formula every time i need the total?

it does it automatically. take an excel class.

No it doesnt seem to, I guess I should specify that this is actually a table in word not in excel .

calculate it in excel first, then copy/paste to Word

Good Idea! I will try that. Thanks man, and to the other people who helped as well.

 

[imported_LoKe]

But if you try to copy and paste from excel, won't you just get the formula and not the actual numbers?

 

[ActuaryTm]

Originally posted by: Orsorum
Mind giving us a sample spreadsheet?

Sample.xls

 

[white]

for some reason the option to automatically update may have gotten turned off. go to tools, options and click on the calculation tab. make sure it's automatically calculating

 

[EyeMWing]

Originally posted by: ActuaryTm

Originally posted by: Orsorum
Mind giving us a sample spreadsheet?

Sample.xls

LOL!

 

[eldorado99]

Originally posted by: ActuaryTm

Originally posted by: Orsorum
Mind giving us a sample spreadsheet?

Sample.xls

lol I have to poop

 

[SuperSix]

F1 rawks

 

[Orsorum]

Originally posted by: ActuaryTm

Originally posted by: Orsorum
Mind giving us a sample spreadsheet?

Sample.xls

lol!

 

[Sheepathon]

Originally posted by: ActuaryTm

Originally posted by: Orsorum
Mind giving us a sample spreadsheet?

Sample.xls

Ahaha, served?