View Single Post
 
Old 11-14-2014, 12:37 PM
bill3kradio bill3kradio is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Nov 2014
Posts: 5
bill3kradio is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
It's a whole lot simpler than that:
{IF{MERGEFIELD dollaramount \# 0}> 650000 "text3" {IF{MERGEFIELD dollaramount \# 0}> 417000 "text2" "text1"}}
I can't see where {MERGEFIELD program} has a role.
Thanks! I will try that.
The program field comes into play because I have several different programs that can also impact the text. 1/1 3/1 5/1 and 7/1. The program in conjunction with the amount determines the text that is used.

the group of three alternatives i posted are repeated for each of the programs.
Reply With Quote