mail merge using if compare 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.
|