PDA

View Full Version : WORD. post formula result



Aleksey
09-06-2007, 01:38 AM
I have a real problem that does't let me to work very fast in Word.
My boss gives me tasks that look like this:
I have a table (say 3 columns and a lot of rows - near 50)

Col 1 ..............Col 2 ...........................Col 3

"Cost" .........(10 + 20*3.5)*2*3*4 ........1920

So my task is to calculate the result of actions in Col 2 and to post it in
Col 3.

I do it with calculator and it is very slowly.
* Col 2 shouldn't show "="
* Col 3 should shou the only result
* Use of menu Table/Formula is very complecated because I have too
much rows.
The ideal variant is to make such a procedures:
- put cursor in the Col 2
- click a buttom or item in context menu or smth else
- and finaly get a result of calculations in Col 3

I think it to be a hard task. But I would be greatefull for those who can help me.

Thank You!

mdmackillop
09-06-2007, 05:35 AM
If you really have to do this in Word, insert a spreadsheet object and do your calculations there.

fumei
09-06-2007, 12:46 PM
Absolutely. Word does not do this very well. It is a word processor.

Doing actual calculations in Word is asking for trouble. Yes, it can do some, but it is not designed for it. In fact, have you actually tried putting (10 + 20*3.5)*2*3*4 into a cell and calculating it with Word? What a mess!

Save yourself pain, use the proper tool.

TonyJollans
09-07-2007, 02:57 AM
I agree fully with Malcolm and Gerry, but if you must do it in Word ...

In your example using row 2 of the table put your cursor in column 3, press Ctrl+F9 and type =B2 and press F9. You can't copy this type of field and have it adjust automatically like you can in Excel but it will get the job done. You could probably record a macro and tweak it to adjust the row number if you really needed to.