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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Porkchop - 27 Sep 2004 14:43 GMT

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.

Reply to this Message

Herb Tyson [MVP] - 28 Sep 2004 03:39 GMT

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.

Signature

Herb Tyson MS MVP
Please respond in the newsgroups so everyone can follow along.
http://www.herbtyson.com

>I am trying to create a requisition form and I want to multiply the
>quantity
[quoted text clipped - 5 lines]
> tax
> rate. I couldn't find anything in Help that actually helped.

Reply to this Message