Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / February 2008

Tip: Looking for answers? Try searching our database.

Merge field comparing dollar amounts?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
JAnderson - 21 Feb 2008 17:11 GMT
Greetings,

Here is the problem.  I have a merge field set up like this:

{IF {MERGEFIELD PRICE}< “$15,000.00” "too cheap" "sell to customer"}

The idea is that if my "Price" field is less than $15,000, I want it to show
"too cheap".  Otherwise, I'd like the field to show "sell to customer".

Currently, the field ALWAYS returns "sell to customer", even if the price
field is less than 15k.  Thus, Word isn't correctly comparing the fields.  
I've tried the switch \# "$,0.00" in my mergefield, but that doesn't help (my
data is already in that format).  

How does one correctly compare dollar amounts within word?
Peter Jamieson - 21 Feb 2008 18:20 GMT
I suggest you try

{ IF { MERGEFIELD price \#0.00 } < 15000 "too cheap" "sell to customer" }

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

> Greetings,
>
[quoted text clipped - 13 lines]
>
> How does one correctly compare dollar amounts within word?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.