Word 2007 - table and equation help

Word 2007 - table and equation help

Author
Discussion

Daniel1

Original Poster:

2,931 posts

199 months

Friday 13th August 2010
quotequote all
im trying to create a table in word 2007, with the last column being a total column.

so i need the equation quantity x price = total but i cant do it frown

help please

ccr32

1,982 posts

219 months

Friday 13th August 2010
quotequote all
Excel and then import into Word?

Daniel1

Original Poster:

2,931 posts

199 months

Friday 13th August 2010
quotequote all
ccr32 said:
Excel and then import into Word?
its fiddly as anything to try and get it to fit and this document is going to be a master for future use.

lestag

4,614 posts

277 months

Friday 13th August 2010
quotequote all
Daniel1 said:
im trying to create a table in word 2007, with the last column being a total column.

so i need the equation quantity x price = total but i cant do it frown

help please
Insert/ Insert Excel Spreadsheet

Instead of insert table , click on chevron (triangle) and you get more options.
thumbup

petemurphy

10,130 posts

184 months

Daniel1

Original Poster:

2,931 posts

199 months

Friday 13th August 2010
quotequote all
petemurphy said:
how do i get it to repeat for the TOTAL column?

AND why oh why cant it just be easy like in excel

petemurphy

10,130 posts

184 months

Friday 13th August 2010
quotequote all
Daniel1 said:
petemurphy said:
how do i get it to repeat for the TOTAL column?

AND why oh why cant it just be easy like in excel
what do u mean repeat? cant u just copy and paste if you mean how can you get the formula to apply for the column?

because excel is a spreadsheet and word is a wordprocessor perhaps wink


CommanderJameson

22,096 posts

227 months

Friday 13th August 2010
quotequote all
Formulae in Word tables is doable (via Word fields) but is entirely less attractive, useful and user-friendly than simply embedding an Excel spreadsheet object in the page.

For example, when you insert rows into a an Excel table that has totals as the final row, Excel is generally smart enough to twiddle the ranges feeding the SUM() functions, so they add up right.

Word doesn't, so you have to manually edit the fields and then force a recalculation. This is just one example of why Word tables are deranged pap.

Hateful.