Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
sooz
 
Posts: n/a
Default formulas in Word


Hiya,

I am updating a Word form template that somebody else has written.
It seems they've used formulas within the table.
They've got 4 columns - quantity, description, unit cost, extended
cost.
The formulas are used to calculate the extended cost, sub-total, gst
and total.
I need to add two extra rows in here, and I thought it would be simple
but it's not!
I've unprotected the template so I can edit it.
I've inserted 2 extra rows at the bottom (just before the sub-total)
and copied and pasted the cells from one of the lines above into the
two new ones.
The only problem is, it doesn't adjust the formulas like Excel does! I
have tried going in and adjusting the formulas myself by right-clicking
on the cell, going to edit field, clicking on Formula and then changing
the cell references to suit the new rows. But I get 'undefined
bookmark' errors!
I have no idea what to do... can anybody help?!

sooz


--
sooz
 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Why dont MS just f**king re-write Word from scratch? Its dogsh*t Word Hater Microsoft Word Help 33 May 5th 23 02:52 PM
How do I "reveal codes" in Word the way I could in Word Perfect? crystal Microsoft Word Help 3 May 11th 06 02:10 AM
Converting Word Perfect forms to Word forms elyse Microsoft Word Help 1 February 15th 06 08:17 PM
WP merge file to Word sstires Tables 4 February 14th 06 06:26 PM
How can Word display full path of a file in the title bar? SAsif Microsoft Word Help 1 January 26th 06 04:32 PM


All times are GMT +1. The time now is 01:35 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"