Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-27-2013, 11:07 AM
treeguy treeguy is offline using merge fields in "if then else" formula Windows XP using merge fields in "if then else" formula 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
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Printing "Fill-In" merge fields vorm Mail Merge 0 07-27-2011 08:22 AM
using merge fields in "if then else" formula How to choose a "List" for certain "Heading" from "Modify" tool? Jamal NUMAN Word 2 07-03-2011 03:11 AM
using merge fields in "if then else" formula Excel 07 formating 17 cells "Need Formula" Raner Excel 2 05-30-2010 02:07 PM
"Microsoft Excel Application" missing in the "Component Services" on win08 sword.fish Excel 0 02-26-2010 02:09 PM
merge field formatting problem with "text to be inserted before" wissam Mail Merge 0 12-13-2009 12:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:47 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft