Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
How do I use Excel formulas in Word?
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? |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
How do I use Excel formulas in Word?
=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 "hotbunz321" wrote in message ... 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? |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
How do I use Excel formulas in Word?
Don't put the forumla in quotes inside the field. With field codes display,
it should look like this { =SUM(LEFT)*350 } -- Herb Tyson MS MVP Please respond in the newsgroups so everyone can follow along. http://www.herbtyson.com "hotbunz321" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word 97 in Windows XP to maintain formatting | Microsoft Word Help | |||
Converting WordPerfect 12 files to Word 2003 | New Users | |||
How to put graphics on envelopes? | Microsoft Word Help | |||
Change paper size; Word changes to invalid margins | New Users | |||
hard space between words. | Microsoft Word Help |