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

eldorado99

Lifer
Feb 16, 2004
36,324
3,163
126
Die! Wrong forum nazis! bang bang bang! :D

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?
 

eldorado99

Lifer
Feb 16, 2004
36,324
3,163
126
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

Lifer
Oct 12, 1999
10,263
3
76
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

Lifer
Dec 26, 2001
27,631
5
81
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

Lifer
Feb 16, 2004
36,324
3,163
126
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 :eek:.
 

dquan97

Lifer
Jul 9, 2002
12,010
3
0
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 :eek:.

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

eldorado99

Lifer
Feb 16, 2004
36,324
3,163
126
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.
 

eldorado99

Lifer
Feb 16, 2004
36,324
3,163
126
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 :eek:.

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.
 

white

Senior member
Nov 2, 2000
988
3
81
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