Form fields and formula

[Margaret Upton]

I have created a table and used the form feature to put in fields with the
last cell doing a calculation formula. The one column I have put
=Sum(B2:b22)*0.38. The second column is =Sum(C2:C22)*5.52. I then want
another cell to add the results of these 2 formulas together, which it will
not do. Does anyone know how to do this please, or alternatively how to
formulate the one cell to do both tasks ie the formulas above and then add
the results together. I know a spreadsheet would do this, but I like to
work in Word as I can add graphics etc more easily. Would be grateful for
some help please.

Margaret

 

[Doug Robbins - Word MVP]

Use

= (Sum(B2:b22)*0.38) + (Sum(C2:C22)*5.52)

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Margaret Upton]

Thank you so very much, that works perfectly.

Kind regards

Margaret