Solved

Creating an equation in Word

Posted on 2011-09-13
3
473 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 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Office 365 is currently available in five editions. Three of them are for business use: Office 365 Business Essentials, Office 365 Business, and Office 365 Business Premium. Two of them are for home/personal use: Office 365 Home and Office 365 Perso…

733 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