Merge field comparing dollar amounts?
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?
|