View Single Post
 
Old 03-27-2013, 11:07 AM
treeguy treeguy is offline Windows XP Office 2010 32bit
Novice
 
Join Date: Mar 2013
Posts: 1
treeguy is on a distinguished road
Default Performing Calculations using Mail Merge Fields

I'm running into a similar problem, and hopefully you can help. I get a syntax error and do not understand why.

Here is the simple calculation I am trying to do:

Cost / (90% * Rent), formatted with no decimals, where

Cost = $3,000.00
Rent = $247.00

which should yield 13.495276653171390013495276653171 but formatted and displayed as 13.

Here is the Word equation I entered:

{ =({MERGEFIELD Cost}/.9*{ MERGEFIELD Rent})) \# "0"}

Why do I get a syntax error?
Reply With Quote