Office 2000 - Word Formulas

Table calculations seem much different in 2000 then previous versions. I am apparently missing something suble that prevents it from working for me. I have created a table (this is in a form) in which 3 columns are numeric and require calculations. I bookmarked (<>) the two cells that I want to use and put the formula in the 3rd thus:

Hours Rate Amount
<hours1> <rate1> =product(hours1,rate1)

The 'Hours' column is a number field to be filled in by the user. The 'Rate' field is a constant on the form and the 'Amount' column is the formula. I currently have two problems I don't understand.

1) When the 'Hours' field is filled in, the corresponding 'Amount' field is not automatically updated. There are check boxes in the properties for when a maco is executed but not updates. At least not that I can find.

2) When I manually update the 'Amount' field (right click - update) I get an error telling me 'Hours1' is an unknown bookmark.

Can anyone point me in the right direction on this? Thanks.

 

Hi gw1500se. I don't have a direct answer for you, but I've found this to be the best bet with all things office related. Hope it helps?

Daizy

 

Is there a reason you are not using Excel for this ?
regards

 

Thanks for the reply. Excel does not lend itself to the other formatting needed on this document. I may however, imbed an Excel spreadsheet in the document to get around the problem and sacrifice some formatting. In any case I am still interested in figuring out why this doesn't work.