[Habitat Calgary]

In a thank you letter, I'd like to equate a donor's support with a tangible
purchase by saying things like 'Your donation of $(merge field 'amount')
purchases the equivalent of (x).'

I'd like text to be inserted in the place of 'X' based on value ranges.
Under $20 = a case of nails, $21-$49 = a door, etc.

How do I define a value range within an If...Then... situation?

Thanks!

[Doug Robbins - Word MVP]

Just use nested If...then...Else fields

{ IF { MERGEFIELD Amount } 20 "a case of nails" { IF { MERGEFIELD Amount }
50 "a door" "what you get for more than 50 } }

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Habitat Calgary" wrote in
message ...
In a thank you letter, I'd like to equate a donor's support with a
tangible
purchase by saying things like 'Your donation of $(merge field 'amount')
purchases the equivalent of (x).'

I'd like text to be inserted in the place of 'X' based on value ranges.
Under $20 = a case of nails, $21-$49 = a door, etc.

How do I define a value range within an If...Then... situation?

Thanks!