A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Tables
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Trying Understand Formulas In Tables



 
 
Thread Tools Display Modes
  #1  
Old February 12th, 2008, 12:33 AM posted to microsoft.public.word.tables
Bill Bradshaw[_2_]
external usenet poster
 
Posts: 8
Default Trying Understand Formulas In Tables

If I enter in the cell

{REF HaulHours} I get the right result.

If I enter in the cell {={REF HaulHours}*10}

I get the syntax error !Syntax Error,*

I am using control F9 to create the braces.

This is starting to drive me nuts.

I hope somebody can save my sanity.

Bill
  #2  
Old February 12th, 2008, 02:28 AM posted to microsoft.public.word.tables
macropod
external usenet poster
 
Posts: 1,231
Default Trying Understand Formulas In Tables

Hi Bill,

Try:
{={HaulHours}*10}

For more information on field-based calculations in Word, check out my Word Field Maths 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=365442
or
http://www.gmayor.com/downloads.htm#Third_party

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Bill Bradshaw" wrote in message ...
If I enter in the cell

{REF HaulHours} I get the right result.

If I enter in the cell {={REF HaulHours}*10}

I get the syntax error !Syntax Error,*

I am using control F9 to create the braces.

This is starting to drive me nuts.

I hope somebody can save my sanity.

Bill


  #3  
Old February 12th, 2008, 05:42 PM posted to microsoft.public.word.tables
Bill Bradshaw[_2_]
external usenet poster
 
Posts: 8
Default Trying Understand Formulas In Tables

Tried it and I still got the error, !Syntax Error,*. For some reason it does
not want to multiply. I protected the form and entered the data to be used
in the formula. I then unprotected the form and performed a shift-F9 on the
formula and the variable value for HaulHours is correct. It just does not
want to multiply by 10. At some point I will replace the 10 with an hourly
labor costs value if the multiplication will ever work. All the other
multiplication formulas in the form work fine. What I am wanting to do
appears to be so simple I do not know where to start debugging it. I will
appreciate any further help or suggestions I get.

I do not know if this makes a difference but it is Word 2003 running on
WinXP Pro SP2 with all current updates.

Bill

"macropod" wrote:

Hi Bill,

Try:
{={HaulHours}*10}

For more information on field-based calculations in Word, check out my Word Field Maths 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=365442
or
http://www.gmayor.com/downloads.htm#Third_party

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Bill Bradshaw" wrote in message ...
If I enter in the cell

{REF HaulHours} I get the right result.

If I enter in the cell {={REF HaulHours}*10}

I get the syntax error !Syntax Error,*

I am using control F9 to create the braces.

This is starting to drive me nuts.

I hope somebody can save my sanity.

Bill



  #4  
Old February 12th, 2008, 11:08 PM posted to microsoft.public.word.tables
macropod
external usenet poster
 
Posts: 1,231
Default Trying Understand Formulas In Tables

Hi Bill,

Are you sure there are no other characters in the field?

What happens if you use a formula field (not a form field) coded as:
{=HaulHours*10}

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Bill Bradshaw" wrote in message ...
Tried it and I still got the error, !Syntax Error,*. For some reason it does
not want to multiply. I protected the form and entered the data to be used
in the formula. I then unprotected the form and performed a shift-F9 on the
formula and the variable value for HaulHours is correct. It just does not
want to multiply by 10. At some point I will replace the 10 with an hourly
labor costs value if the multiplication will ever work. All the other
multiplication formulas in the form work fine. What I am wanting to do
appears to be so simple I do not know where to start debugging it. I will
appreciate any further help or suggestions I get.

I do not know if this makes a difference but it is Word 2003 running on
WinXP Pro SP2 with all current updates.

Bill

"macropod" wrote:

Hi Bill,

Try:
{={HaulHours}*10}

For more information on field-based calculations in Word, check out my Word Field Maths 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=365442
or
http://www.gmayor.com/downloads.htm#Third_party

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Bill Bradshaw" wrote in message
...
If I enter in the cell

{REF HaulHours} I get the right result.

If I enter in the cell {={REF HaulHours}*10}

I get the syntax error !Syntax Error,*

I am using control F9 to create the braces.

This is starting to drive me nuts.

I hope somebody can save my sanity.

Bill




  #5  
Old February 12th, 2008, 11:47 PM posted to microsoft.public.word.tables
Bill Bradshaw[_2_]
external usenet poster
 
Posts: 8
Default Trying Understand Formulas In Tables

That gets rid of the syntax error but introduces another error. The haul
hours should be 137 and that is what is calculated for the HaulHours
bookmark. But in the formula written as you showed it HaulHours becomes
100493.1. The only way I have found I can get the right variable amount for
the HaulHours I want to use in the calculation is to REF it. Of course when
I REF it and then try to multiply by 10 I get the syntax error.

What is confusing is why does the form assign wrong 100493.1 to the non REF
HaulHours bookmark and the correct 137 HaulHours when I REF it. Of course
when I REF it I am back to the syntax error problem.

Bill

"macropod" wrote:

Hi Bill,

Are you sure there are no other characters in the field?

What happens if you use a formula field (not a form field) coded as:
{=HaulHours*10}

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Bill Bradshaw" wrote in message ...
Tried it and I still got the error, !Syntax Error,*. For some reason it does
not want to multiply. I protected the form and entered the data to be used
in the formula. I then unprotected the form and performed a shift-F9 on the
formula and the variable value for HaulHours is correct. It just does not
want to multiply by 10. At some point I will replace the 10 with an hourly
labor costs value if the multiplication will ever work. All the other
multiplication formulas in the form work fine. What I am wanting to do
appears to be so simple I do not know where to start debugging it. I will
appreciate any further help or suggestions I get.

I do not know if this makes a difference but it is Word 2003 running on
WinXP Pro SP2 with all current updates.

Bill

"macropod" wrote:

Hi Bill,

Try:
{={HaulHours}*10}

For more information on field-based calculations in Word, check out my Word Field Maths 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=365442
or
http://www.gmayor.com/downloads.htm#Third_party

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Bill Bradshaw" wrote in message
...
If I enter in the cell

{REF HaulHours} I get the right result.

If I enter in the cell {={REF HaulHours}*10}

I get the syntax error !Syntax Error,*

I am using control F9 to create the braces.

This is starting to drive me nuts.

I hope somebody can save my sanity.

Bill




  #6  
Old February 12th, 2008, 11:55 PM posted to microsoft.public.word.tables
macropod
external usenet poster
 
Posts: 1,231
Default Trying Understand Formulas In Tables

Hi Bill,

Are you sure there are no other characters in the field?

What happens if you use a formula field (not a form field) coded as:
{=HaulHours}
(ie no multiplication)
and
{=HaulHours*1}

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Bill Bradshaw" wrote in message ...
That gets rid of the syntax error but introduces another error. The haul
hours should be 137 and that is what is calculated for the HaulHours
bookmark. But in the formula written as you showed it HaulHours becomes
100493.1. The only way I have found I can get the right variable amount for
the HaulHours I want to use in the calculation is to REF it. Of course when
I REF it and then try to multiply by 10 I get the syntax error.

What is confusing is why does the form assign wrong 100493.1 to the non REF
HaulHours bookmark and the correct 137 HaulHours when I REF it. Of course
when I REF it I am back to the syntax error problem.

Bill

"macropod" wrote:

Hi Bill,

Are you sure there are no other characters in the field?

What happens if you use a formula field (not a form field) coded as:
{=HaulHours*10}

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Bill Bradshaw" wrote in message
...
Tried it and I still got the error, !Syntax Error,*. For some reason it does
not want to multiply. I protected the form and entered the data to be used
in the formula. I then unprotected the form and performed a shift-F9 on the
formula and the variable value for HaulHours is correct. It just does not
want to multiply by 10. At some point I will replace the 10 with an hourly
labor costs value if the multiplication will ever work. All the other
multiplication formulas in the form work fine. What I am wanting to do
appears to be so simple I do not know where to start debugging it. I will
appreciate any further help or suggestions I get.

I do not know if this makes a difference but it is Word 2003 running on
WinXP Pro SP2 with all current updates.

Bill

"macropod" wrote:

Hi Bill,

Try:
{={HaulHours}*10}

For more information on field-based calculations in Word, check out my Word Field Maths 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=365442
or
http://www.gmayor.com/downloads.htm#Third_party

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Bill Bradshaw" wrote in message
...
If I enter in the cell

{REF HaulHours} I get the right result.

If I enter in the cell {={REF HaulHours}*10}

I get the syntax error !Syntax Error,*

I am using control F9 to create the braces.

This is starting to drive me nuts.

I hope somebody can save my sanity.

Bill





  #7  
Old February 13th, 2008, 12:40 AM posted to microsoft.public.word.tables
Bill Bradshaw[_2_]
external usenet poster
 
Posts: 8
Default Trying Understand Formulas In Tables

I did not really understand how bookmarks worked so I was pretty dumb. I was
selecting the entire cell when setting the bookmark instead of just the
formula. Everything is working. Sorry I put you through this.

Bill

"macropod" wrote:

Hi Bill,

Are you sure there are no other characters in the field?

What happens if you use a formula field (not a form field) coded as:
{=HaulHours}
(ie no multiplication)
and
{=HaulHours*1}

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Bill Bradshaw" wrote in message ...
That gets rid of the syntax error but introduces another error. The haul
hours should be 137 and that is what is calculated for the HaulHours
bookmark. But in the formula written as you showed it HaulHours becomes
100493.1. The only way I have found I can get the right variable amount for
the HaulHours I want to use in the calculation is to REF it. Of course when
I REF it and then try to multiply by 10 I get the syntax error.

What is confusing is why does the form assign wrong 100493.1 to the non REF
HaulHours bookmark and the correct 137 HaulHours when I REF it. Of course
when I REF it I am back to the syntax error problem.

Bill

"macropod" wrote:

Hi Bill,

Are you sure there are no other characters in the field?

What happens if you use a formula field (not a form field) coded as:
{=HaulHours*10}

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Bill Bradshaw" wrote in message
...
Tried it and I still got the error, !Syntax Error,*. For some reason it does
not want to multiply. I protected the form and entered the data to be used
in the formula. I then unprotected the form and performed a shift-F9 on the
formula and the variable value for HaulHours is correct. It just does not
want to multiply by 10. At some point I will replace the 10 with an hourly
labor costs value if the multiplication will ever work. All the other
multiplication formulas in the form work fine. What I am wanting to do
appears to be so simple I do not know where to start debugging it. I will
appreciate any further help or suggestions I get.

I do not know if this makes a difference but it is Word 2003 running on
WinXP Pro SP2 with all current updates.

Bill

"macropod" wrote:

Hi Bill,

Try:
{={HaulHours}*10}

For more information on field-based calculations in Word, check out my Word Field Maths 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=365442
or
http://www.gmayor.com/downloads.htm#Third_party

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Bill Bradshaw" wrote in message
...
If I enter in the cell

{REF HaulHours} I get the right result.

If I enter in the cell {={REF HaulHours}*10}

I get the syntax error !Syntax Error,*

I am using control F9 to create the braces.

This is starting to drive me nuts.

I hope somebody can save my sanity.

Bill






 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:09 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.