Solved

Creating an equation in Word

Posted on 2011-09-13
3
475 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst (Microsoft MVP / EE MVE) 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
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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

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 demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

726 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