[bill koeninger]

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.