[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 483
  • Last Modified:

Creating an equation in Word

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
Peakpp
Asked:
Peakpp
  • 2
1 Solution
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
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
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
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
 
PeakppAuthor Commented:
thanks for the help.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now