Solved

Creating an equation in Word

Posted on 2011-09-13
3
469 Views
Last Modified: 2012-05-12
I am trying to create a price list in word with formulas similar to excel.  I basically have a price list designed in word and have inserted some columns with the discount structure in the header column, but I can't seem to figure out how to do the equations.

I need to have 3 columns of pricing based off their regular price.  If was doing it in excel the formulas would read

=column:row*0.98 for the first volume discount
=column:row*0.965 for the 2nd volume discount
=column:row*0.95 for the 3rd volume discount

can someone please assist me with this.  It is time sensitive and urgent.  Thank you.

WHSL-List.RevC3test.docx
0
Comment
Question by:Peakpp
  • 2
3 Comments
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst earned 500 total points
ID: 36534191
Hello,

this will be a real PITA. Although you can easily create a formula to do a simple calculation, Word is not Excel, and you cannot copy that formula down and expect the references to adjust.

To address a cell in the Word table, treat each cell as if it were an Excel cell in an A1 convention. The table headers are in row 1. The Item # is in column A, so the Item # for the first product is in cell A3.

Click the cell in row 3 in the column labelled "Any Qty 2% Off" (that's column I).
Hit Alt-F9 to display field codes
Hit Ctrl-F9 to enter a field into that table cell
Between the curly brackets that you now see, click and enter

=G3*0.98

(That's assuming you want to reduce the WHSL price by 2%. Your question does not really specify what the source value is.)

Right-click the field and select "Update Field"
Hit Alt-F9 again to toggle back to normal view

See the result of the calculation in the cell.

Now, there is no easy way to drag this formula down and expect it to adjust the cell reference to G4, G5, etc.

Word is not Excel.

It would be much easier to create the table in Excel and then embed it in the Word file. That way, you can do the calculations in Excel and show the finished results in Word.

cheers, teylyn


PS: It is not really necessary to post a 5+ MB file to illustrate that issue. Also, you've left it up to our guess work as to what cells shall be included in the calculation.  You probably would have gotten faster help with a smaller file attachment and more explicit descriptions, like which column to calculate the discount for.
0
 
LVL 50

Expert Comment

by:Ingeborg Hawighorst
ID: 36534204
Also, note that the field codes will not instantly update when you change the source data in the table. You need to update the fields manually.

For an individual field, right-click and select Update Field.

For the whole document, hit Alt-A to select all content, then hit F9 to refresh all fields.
0
 

Author Closing Comment

by:Peakpp
ID: 36534351
thanks for the help.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
MS Word document > cursor placement 5 24
Deleting Unselectable Lines in Word 2013 2 32
Easy Excel formula needed 4 26
Sum iF  based on a null cell 11 29
This article describes how to use the Send to Mail Recipient command. The instructions apply generally to Office 2007 and later versions, but Microsoft® Word 2013 was used for the specific steps and figures.  What is Send to Mail Recipient? Send…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now