View Single Post
 
Old 11-14-2014, 08:59 AM
bill3kradio bill3kradio is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Nov 2014
Posts: 5
bill3kradio is on a distinguished road
Default using if and compare with multiple criteria and ranges of values

Help!

I am working on a document that needs to fill in text that is dependent on amount ranges in a single mergefield. I have three ranges of values and text associated with each.

The ranges are
0 - 417000
417001 - 650000
650001 and higher

I can get two of the three to work but not all three at once. Here's what I have:

{ If { = and ( { compare { mergefield_program } = "1/1" }, { compare { mergefield_dollaramount } < 417001 } ) } = 1 "text1" "" }

{ If { = and ( { compare { mergefield_program } = "1/1" }, { compare { mergefield_dollaramount } > 417000 < 650001 } ) } = 1 "text2" "" }

{ If { = and ( { compare { mergefield_program } = "1/1" }, { compare { mergefield_dollaramount } > 650001 } ) } = 1 "text3" "" }

I have tried multiple iterations of the < and > but nothing seems to work.

Any suggestions? My head is starting to hurt from pounding it against this brick wall of a problem.
Reply With Quote