How do I do multiply one cell by another in a table?

P

Porkchop

I am trying to create a requisition form and I want to multiply the quantity
cell by the unit price cell. I've tried entering the formula several
different ways, but keep getting errors such as, "UP1 not found in the table"
(UP1 being the first unit price cell). I can subtotal the extended price
column without any problem, but I also can't multiply the subtotal by the tax
rate. I couldn't find anything in Help that actually helped.
 
H

Herb Tyson [MVP]

What have you tried? And what version of Word are you using?

Using Word 2003 (probably earlier versions, too), you need to use field
codes to perform the multiplication. Suppose I have a 1-row table, with 5
and 6, and I want to multiply them:


5 | 6 | {=a1 * b1}

The formula shown needs to be inserted inside field braces. You insert field
braces (among other ways) by pressing Ctrl+F9. Then insert the formula as
shown (including = sign). Finally, press F9 to update the field and get the
result.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word VBA - Automatic change content of a cell in table using dropdown list 5
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Table Formula 3
how can I multiply a column by only one cell? 4
how do I multiply numbers across in a table 2
How do I link a cell in a workbook? 1
How do I multiply ALL CELL in spreadsheet at once by .5 ? 4
How do I multiply either column 1 or column 2 by same multiplier? 2

Top