A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Can you add/multiply using Word?



 
 
Thread Tools Display Modes
  #1  
Old March 15th, 2010, 06:41 PM posted to microsoft.public.word.docmanagement
tjsmags
external usenet poster
 
Posts: 210
Default Can you add/multiply using Word?

I want to create a Hot Lunch form for our school. Students will order x
amount of hot dogs multiplied by $x.xx (price) equalling the total amount due
($x.xx). Is this possible? Do I create this in table format, or does it
matter?
--
Thank you.

  #2  
Old March 15th, 2010, 06:57 PM posted to microsoft.public.word.docmanagement
Stefan Blom[_3_]
external usenet poster
 
Posts: 4,556
Default Can you add/multiply using Word?

To perform (simple) calculations in table cells, you can make use of formula fields, which can be added via Table Tools Layout tab |
Formula (Word 2007) or via Table | Formula (Word 97-2003). You refer to cells the same way as in an Excel spreadsheet, that is, by
using letters for columns and numbers for rows.

If you change the numbers in the cell, you will have to update the formula fields: select the cells and press F9.

--
Stefan Blom
Microsoft Word MVP



"tjsmags" wrote in message ...
I want to create a Hot Lunch form for our school. Students will order x
amount of hot dogs multiplied by $x.xx (price) equalling the total amount due
($x.xx). Is this possible? Do I create this in table format, or does it
matter?
--
Thank you.








  #3  
Old March 16th, 2010, 06:20 AM posted to microsoft.public.word.docmanagement
Graham Mayor
external usenet poster
 
Posts: 18,297
Default Can you add/multiply using Word?

That doesn't sound a very healthy diet for school kids, but you can also
achieve this with a protected form and a calculated form field. Check the
calculate on exit check box of the contributing fields to update the
calculation.

Even more elegant, you could employ a userform to collect the choices and
enter the results in the document - For the basics, see Word MVP FAQ -
Userforms
http://word.mvps.org/FAQs/Userforms.htm

for a more in depth explanation, see
http://gregmaxey.mvps.org/Create_and...a_UserForm.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



"tjsmags" wrote in message
...
I want to create a Hot Lunch form for our school. Students will order x
amount of hot dogs multiplied by $x.xx (price) equalling the total amount
due
($x.xx). Is this possible? Do I create this in table format, or does it
matter?
--
Thank you.



  #4  
Old March 16th, 2010, 02:36 PM posted to microsoft.public.word.docmanagement
Shane Carpenter
external usenet poster
 
Posts: 16
Default Can you add/multiply using Word?

You can do this by doing it two ways depending if this is a one time deal or
you want to edit it in the future.

One Time: just type =9*9 and push enter and it will put 81 in the box.

Edit in Futu Name a excel box price and another quantity. Then in the
third you type =price*quantity. It will then change the total every time you
modify.

"tjsmags" wrote:

I want to create a Hot Lunch form for our school. Students will order x
amount of hot dogs multiplied by $x.xx (price) equalling the total amount due
($x.xx). Is this possible? Do I create this in table format, or does it
matter?
--
Thank you.

  #5  
Old March 19th, 2010, 12:40 PM posted to microsoft.public.word.docmanagement
Stefan Blom[_3_]
external usenet poster
 
Posts: 4,556
Default Can you add/multiply using Word?

Note that in Word you will have to do this in the Formula dialog box (or the
Field dialog box inserting a formula field).

--
Stefan Blom
Microsoft Word MVP



"Shane Carpenter" wrote in
message ...
You can do this by doing it two ways depending if this is a one time deal
or
you want to edit it in the future.

One Time: just type =9*9 and push enter and it will put 81 in the box.

Edit in Futu Name a excel box price and another quantity. Then in the
third you type =price*quantity. It will then change the total every time
you
modify.

"tjsmags" wrote:

I want to create a Hot Lunch form for our school. Students will order x
amount of hot dogs multiplied by $x.xx (price) equalling the total amount
due
($x.xx). Is this possible? Do I create this in table format, or does it
matter?
--
Thank you.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:50 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.