Miscalculation

L

Linda George

I am using a calculation in a table with form fields and I am no
getting the correct answer. I just want to add three cells together t
get a grand total.

"Subtotal" is a calculation field that sums the total above usin
=SUM(ABOVE).

"Tax" is a user entered number (no calculation)

"SH" is a user entered number (no calculation)

When I put in a calculation for the grand total field for the total o
all the above =(Subtotal)+(Tax)+(SH) the subtotal amount is entere
twice. It must be a logical error, but I don't see where I have aske
the subtotal to enter into the equation twice.
Can anyone help?
Thank you.
Linda Georg
 
D

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT

This is a bug in Word. In a formfield calculation, you cannot use as an
input to the calculation another formfield that itself if the result of a
calculation. For workarounds, see the Knowledge Base Article at:

http://support.microsoft.com/default.aspx?scid=kb;en-us;110656

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top