using if and compare with multiple criteria and ranges of values

bill3kradio · #3 11-14-2014, 12:37 PM

Quote:

Originally Posted by macropod

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.

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