Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
hotbunz321 hotbunz321 is offline
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.word.tables
Tony Jollans Tony Jollans is offline
external usenet poster
 
Posts: 1,308
Default 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   Report Post  
Posted to microsoft.public.word.tables
Herb Tyson [MVP] Herb Tyson [MVP] is offline
external usenet poster
 
Posts: 2,936
Default 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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word 97 in Windows XP to maintain formatting Charlie''s Word VBA questions Microsoft Word Help 22 May 20th 23 08:51 PM
Converting WordPerfect 12 files to Word 2003 Curious New Users 4 May 19th 23 02:48 PM
How to put graphics on envelopes? Steve Koenig Microsoft Word Help 21 April 29th 23 02:47 AM
Change paper size; Word changes to invalid margins OhioTech New Users 10 July 6th 06 02:00 PM
hard space between words. Sandy L Microsoft Word Help 7 May 5th 06 08:25 PM


All times are GMT +1. The time now is 05:36 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"