Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Tables / April 2008

Tip: Looking for answers? Try searching our database.

Form fields and formula

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Margaret Upton - 22 Apr 2008 21:33 GMT
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 - 22 Apr 2008 23:24 GMT
Use

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

Signature

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

>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
[quoted text clipped - 7 lines]
>
> Margaret
Margaret Upton - 23 Apr 2008 09:26 GMT
Thank you so very much, that works perfectly.

Kind regards

Margaret

> Use
>
[quoted text clipped - 11 lines]
>>
>> Margaret
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.