• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

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

eldorado99

eldorado99

Lifer
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?
 
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?
 
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?
Click to expand...

it does it automatically. take an excel class.
 
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?
Click to expand...

Mind giving us a sample spreadsheet?
 
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?
Click to expand...

it does it automatically. take an excel class.
Click to expand...

No it doesnt seem to, I guess I should specify that this is actually a table in word not in excel 😱.
 
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?
Click to expand...

it does it automatically. take an excel class.
Click to expand...

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

calculate it in excel first, then copy/paste to Word
 
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?
Click to expand...

Mind giving us a sample spreadsheet?
Click to expand...

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.
 
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?
Click to expand...

it does it automatically. take an excel class.
Click to expand...

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

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

Good Idea! I will try that. Thanks man, and to the other people who helped as well.
 
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
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top