How do I use Excel formulas in Word?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

hotbunz321 - 27 Sep 2006 19:55 GMT

I am working on a billing statement in Word, using the table. I have four
columns. THe last two colums is an hours column (i.e. .25 or .50) and an
amount column. I want the amount column to automatically multiply itself by
the hours column. My problem is, every time I use the formula
"=SUM(LEFT)*350", I get the "Syntax error" message.

What am I doing wrong?

Reply to this Message

Tony Jollans - 27 Sep 2006 20:08 GMT

=SUM(LEFT)*350 is a valid formula (I just cut and pasted from here to a new
field in a table and it worked) but I don't understand how it relates to the
rest of your description so I don't know what you're doing wrong. How are
you entering the formula?

--
Enjoy,
Tony

> I am working on a billing statement in Word, using the table. I have four
> columns. THe last two colums is an hours column (i.e. .25 or .50) and an
[quoted text clipped - 3 lines]
>
> What am I doing wrong?

Reply to this Message

Herb Tyson [MVP] - 30 Sep 2006 03:58 GMT

Don't put the forumla in quotes inside the field. With field codes display,
it should look like this { =SUM(LEFT)*350 }

Signature

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

>I am working on a billing statement in Word, using the table. I have four
> columns. THe last two colums is an hours column (i.e. .25 or .50) and an
[quoted text clipped - 4 lines]
>
> What am I doing wrong?

Reply to this Message