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?