| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
syntax errors
I am trying to put a formula into the page x of y field in my footer. Word
help tells which formula to use, but I get a syntax error every time and every way I use it. I am starting my pagination with a number other than one and need the y value to calculate from that point forward. the formula I'm using is { = (45 -1) + { NUMPAGES } } as stated to use by Microsoft. The syntax error I get is !Syntax Error, { I have tried all manner of spacing and even tried using the SUM formula method with values separated with a comma. Does anyone know what I did wrong? |
|
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
syntax errors
Do you use Ctrl+F9 to insert field? It works for me.
"LW" wrote: I am trying to put a formula into the page x of y field in my footer. Word help tells which formula to use, but I get a syntax error every time and every way I use it. I am starting my pagination with a number other than one and need the y value to calculate from that point forward. the formula I'm using is { = (45 -1) + { NUMPAGES } } as stated to use by Microsoft. The syntax error I get is !Syntax Error, { I have tried all manner of spacing and even tried using the SUM formula method with values separated with a comma. Does anyone know what I did wrong? |
|
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
syntax errors
As Harvey indicates you have typed the second set of {} brackets from the
keyboard. You must either insert the Numpages field or use CTRL+F9 for the brackets, then update the field (F9). And why use 45-1? What's wrong with 44? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org LW wrote: I am trying to put a formula into the page x of y field in my footer. Word help tells which formula to use, but I get a syntax error every time and every way I use it. I am starting my pagination with a number other than one and need the y value to calculate from that point forward. the formula I'm using is { = (45 -1) + { NUMPAGES } } as stated to use by Microsoft. The syntax error I get is !Syntax Error, { I have tried all manner of spacing and even tried using the SUM formula method with values separated with a comma. Does anyone know what I did wrong? |
|
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
syntax errors
If you use (44) it won't work properly and it will show (44)! I couldn't
figure out the reaon of this special formatting but that's the way it is! "Graham Mayor" wrote: As Harvey indicates you have typed the second set of {} brackets from the keyboard. You must either insert the Numpages field or use CTRL+F9 for the brackets, then update the field (F9). And why use 45-1? What's wrong with 44? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org LW wrote: I am trying to put a formula into the page x of y field in my footer. Word help tells which formula to use, but I get a syntax error every time and every way I use it. I am starting my pagination with a number other than one and need the y value to calculate from that point forward. the formula I'm using is { = (45 -1) + { NUMPAGES } } as stated to use by Microsoft. The syntax error I get is !Syntax Error, { I have tried all manner of spacing and even tried using the SUM formula method with values separated with a comma. Does anyone know what I did wrong? |
|
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
syntax errors
Hi Harvey,
If I use (44) + { NUMPAGES } and NUMPAGES = 1, I get (43). In some systems, negative numbers are represented by numbers in parentheses. Looks like Word recognises (44) as being the same as -44. So, (44) + 1 = -44 + 1 = -43 = (43) But if expressions are involved, Word seems to use the parentheses for grouping. E.g. { = 3 * 4 - 1 } = 12 - 1 = 11 and { = 3 * (4 - 1) } = 3 * 3 = 9 Cheers. Ed "Harvey" wrote: If you use (44) it won't work properly and it will show (44)! I couldn't figure out the reaon of this special formatting but that's the way it is! "Graham Mayor" wrote: As Harvey indicates you have typed the second set of {} brackets from the keyboard. You must either insert the Numpages field or use CTRL+F9 for the brackets, then update the field (F9). And why use 45-1? What's wrong with 44? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org LW wrote: I am trying to put a formula into the page x of y field in my footer. Word help tells which formula to use, but I get a syntax error every time and every way I use it. I am starting my pagination with a number other than one and need the y value to calculate from that point forward. the formula I'm using is { = (45 -1) + { NUMPAGES } } as stated to use by Microsoft. The syntax error I get is !Syntax Error, { I have tried all manner of spacing and even tried using the SUM formula method with values separated with a comma. Does anyone know what I did wrong? |
|
#6
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
syntax errors
you are correct that's the logic behind it.
"Ed" wrote: Hi Harvey, If I use (44) + { NUMPAGES } and NUMPAGES = 1, I get (43). In some systems, negative numbers are represented by numbers in parentheses. Looks like Word recognises (44) as being the same as -44. So, (44) + 1 = -44 + 1 = -43 = (43) But if expressions are involved, Word seems to use the parentheses for grouping. E.g. { = 3 * 4 - 1 } = 12 - 1 = 11 and { = 3 * (4 - 1) } = 3 * 3 = 9 Cheers. Ed "Harvey" wrote: If you use (44) it won't work properly and it will show (44)! I couldn't figure out the reaon of this special formatting but that's the way it is! "Graham Mayor" wrote: As Harvey indicates you have typed the second set of {} brackets from the keyboard. You must either insert the Numpages field or use CTRL+F9 for the brackets, then update the field (F9). And why use 45-1? What's wrong with 44? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org LW wrote: I am trying to put a formula into the page x of y field in my footer. Word help tells which formula to use, but I get a syntax error every time and every way I use it. I am starting my pagination with a number other than one and need the y value to calculate from that point forward. the formula I'm using is { = (45 -1) + { NUMPAGES } } as stated to use by Microsoft. The syntax error I get is !Syntax Error, { I have tried all manner of spacing and even tried using the SUM formula method with values separated with a comma. Does anyone know what I did wrong? |
|
#7
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
syntax errors
So don't put the 44 in brackets
{ = 44 + { NUMPAGES } } -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Harvey wrote: If you use (44) it won't work properly and it will show (44)! I couldn't figure out the reaon of this special formatting but that's the way it is! "Graham Mayor" wrote: As Harvey indicates you have typed the second set of {} brackets from the keyboard. You must either insert the Numpages field or use CTRL+F9 for the brackets, then update the field (F9). And why use 45-1? What's wrong with 44? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org LW wrote: I am trying to put a formula into the page x of y field in my footer. Word help tells which formula to use, but I get a syntax error every time and every way I use it. I am starting my pagination with a number other than one and need the y value to calculate from that point forward. the formula I'm using is { = (45 -1) + { NUMPAGES } } as stated to use by Microsoft. The syntax error I get is !Syntax Error, { I have tried all manner of spacing and even tried using the SUM formula method with values separated with a comma. Does anyone know what I did wrong? |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find syntax for /*..........*/ ? | Microsoft Word Help | |||
| Formula - Syntax Error | Tables | |||
| Mailmerge calculations syntax | Mailmerge | |||
| If Formula syntax error | Tables | |||
| Macro Syntax | New Users | |||
Linear Mode
