using if and compare with multiple criteria and ranges of values

bill3kradio · #5 11-14-2014, 02:17 PM

Quote:

Originally Posted by macropod

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
I need to add multiple values based on multiple criteria in a cell not sure what to do	AUHAMM	Excel	3	10-27-2014 09:11 PM
Lookup multiple values and compare different scenarios to get a specific result	mws	Excel	5	05-24-2014 04:52 AM
transpose values based on mulitple criteria	mlttkw	Excel	1	12-06-2013 02:00 AM
Compare content of two ranges INCLUDING FORMATTING	delasson	Word VBA	3	12-10-2012 03:54 AM
Change values in cells based on criteria	SaneMan	Excel Programming	2	02-02-2012 07:58 AM