D
Dudely
I finally figured out what gives the dreaded "UNEXPECTED END OF
FORMULA" message and how to fix it.
Lets say you're trying to do a calculation such as Quantity1 +
Quantity2
Here's the right way to do it:
Hit CTRL-F9. That will place a pair of braces {} where your cursor
is, except it's not just a normal pair of braces, it comes "shaded".
I'll let someone else explain the details of that.
Next, move your cursor inside the braces. Hit CTRL-F9 again.
That will give you a second pair of braces. { {} } Move the cursor
again so it's next to that second set you just created and hit CTRL-F9
again. You should end up with { {} {} }. If you don't move your
cursor, you'll end up with { { { } }}, which isn't what you want.
Now, add in your mergefields - and here's the really important part.
Do NOT use the "insert mergefield" button - this is what causes the
error! Instead, HAND TYPE "MERGEFIELD Quantity1" w/out the quotes of
course, and where "Quantity1" is your specific mergefield. Do the
same for quantity2 and/or any other fields you're using. Simply
repeat the above braces inserts for each field. I find it easiest to
insert all of my braces first, and then fill them in with the proper
mergefields, otherwise I quickly get lost as to what goes where.
So, for the above example you'd end up with { { MERGEFIELD Quantity1}
+ {MERGEFIELD Quantity2} }
I'm not sure if spaces are important or not, if you have problems, try
adding extra spaces between the braces and the words.
Now, to make this work you need to add in an equal sign at the
beginning... like this:
{ = { MERGEFIELD Quantity1} + {MERGEFIELD Quantity2} }
Finally some notes. Operators (like plus, minus, multiply, divide,
etc.) and constants (like integers and things) go inbetween brace
fields. Note where the above plus sign is placed.
I hope that solves this problem once and for all. I haven't seen the
answer anywhere else on the Net.
- APB aka Dudely
FORMULA" message and how to fix it.
Lets say you're trying to do a calculation such as Quantity1 +
Quantity2
Here's the right way to do it:
Hit CTRL-F9. That will place a pair of braces {} where your cursor
is, except it's not just a normal pair of braces, it comes "shaded".
I'll let someone else explain the details of that.
Next, move your cursor inside the braces. Hit CTRL-F9 again.
That will give you a second pair of braces. { {} } Move the cursor
again so it's next to that second set you just created and hit CTRL-F9
again. You should end up with { {} {} }. If you don't move your
cursor, you'll end up with { { { } }}, which isn't what you want.
Now, add in your mergefields - and here's the really important part.
Do NOT use the "insert mergefield" button - this is what causes the
error! Instead, HAND TYPE "MERGEFIELD Quantity1" w/out the quotes of
course, and where "Quantity1" is your specific mergefield. Do the
same for quantity2 and/or any other fields you're using. Simply
repeat the above braces inserts for each field. I find it easiest to
insert all of my braces first, and then fill them in with the proper
mergefields, otherwise I quickly get lost as to what goes where.
So, for the above example you'd end up with { { MERGEFIELD Quantity1}
+ {MERGEFIELD Quantity2} }
I'm not sure if spaces are important or not, if you have problems, try
adding extra spaces between the braces and the words.
Now, to make this work you need to add in an equal sign at the
beginning... like this:
{ = { MERGEFIELD Quantity1} + {MERGEFIELD Quantity2} }
Finally some notes. Operators (like plus, minus, multiply, divide,
etc.) and constants (like integers and things) go inbetween brace
fields. Note where the above plus sign is placed.
I hope that solves this problem once and for all. I haven't seen the
answer anywhere else on the Net.
- APB aka Dudely