using if and compare with multiple criteria and ranges of values

		Microsoft Office Forums > Microsoft Word > Mail Merge
using if and compare with multiple criteria and ranges of values

FAQ

Thread Tools

Display Modes

11-17-2014, 01:06 PM

bill3kradio bill3kradio is offline

Windows 7 64bit using if and compare with multiple criteria and ranges of values

Office 2013

Novice

Join Date: Nov 2014

Posts: 5

Figured it out!

I added a third condition to the solution already provided.

{if {mergefield_program} = "1/1 ARM*" {if {mergefield_program}= "* - special"{if mergefield_amount}>650000

I then used the exact same syntax except the 2nd statement is "<> - special".

That seems to do the trick.

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:54 AM.