Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
JAnderson JAnderson is offline
external usenet poster
 
Posts: 21
Default 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?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Merge field comparing dollar amounts?

I suggest you try

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



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

"JAnderson" wrote in message
...
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?


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
I am trying to merge dollar amounts from an Excel spreadsheet Mary W Mailmerge 1 March 9th 07 06:53 PM
right justify dollar amounts Jason.Bradley Mailmerge 3 December 18th 06 07:12 PM
Mail Merge specific amounts of line items Mike C Mailmerge 1 October 7th 06 07:04 AM
mail merge dollar amounts Joan Microsoft Word Help 1 May 18th 06 07:05 PM
How do I turn dollar amounts into words? Theresa Wright New Users 5 January 25th 05 11:28 AM


All times are GMT +1. The time now is 06:48 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"