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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|