|
|
|
|
#1
11-14-2014, 12:23 PM
|
||||
|
||||
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.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
#2
11-14-2014, 12:37 PM
|
|||
|
|||
|
Quote:
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 |
Windows 7 64bit 
Office 2010 32bit
Hybrid Mode