using merge fields in "if then else" formula

		Microsoft Office Forums > Microsoft Word > Mail Merge
using merge fields in "if then else" formula

03-27-2013, 02:50 PM

macropod

Windows 7 64bit using merge fields in "if then else" formula

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

You have too many ')'! Your field should be coded along the lines of:

{={MERGEFIELD Cost}*{MERGEFIELD Rent}/0.9 \# "0"}

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Printing "Fill-In" merge fields	vorm	Mail Merge	0	07-27-2011 08:22 AM
How to choose a "List" for certain "Heading" from "Modify" tool?	Jamal NUMAN	Word	2	07-03-2011 03:11 AM
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 11:14 AM.