Thread: [Solved] using if and compare with multiple criteria and ranges of values
View Single Post
 
Old 11-14-2014, 02:17 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
In that case, you could use:
{IF{MERGEFIELD program}= "1/1" {IF{MERGEFIELD dollaramount \# 0}> 650000 "text3" {IF{MERGEFIELD dollaramount \# 0}> 417000 "text2" "text1"}}}
{IF{MERGEFIELD program}= "3/1" {IF{MERGEFIELD dollaramount \# 0}> 650000 "text3" {IF{MERGEFIELD dollaramount \# 0}> 417000 "text2" "text1"}}}
{IF{MERGEFIELD program}= "5/1" {IF{MERGEFIELD dollaramount \# 0}> 650000 "text3" {IF{MERGEFIELD dollaramount \# 0}> 417000 "text2" "text1"}}}
{IF{MERGEFIELD program}= "7/1" {IF{MERGEFIELD dollaramount \# 0}> 650000 "text3" {IF{MERGEFIELD dollaramount \# 0}> 417000 "text2" "text1"}}}
Thank you so much! That worked!

I've been bouncing off this problem for two days.

Most of what I know about if then in Word is self taught from what I can find on the net so this is extremely helpful.

Thanks again.
Reply With Quote