IF Statements for a several ranges of values using Mail Merge

		Microsoft Office Forums > Microsoft Word > Mail Merge
IF Statements for a several ranges of values using Mail Merge

05-01-2019, 09:40 PM

macropod

Windows 7 64bit IF Statements for a several ranges of values using Mail Merge

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,515

Another way:
{QUOTE{=INT({MERGEFIELD PriorityScore }/5)-1 \# "'{=INT(({MERGEFIELD PriorityScore }-10)/5)-1 \# "'Very High';'High'"}';'Low';'Medium'"}

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Tags

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
I know nothing about mail merge, but need help with conditional statements	briyosa	Word	1	03-27-2017 10:17 PM
Using multiple IF statements on a mail merge	ajh19742000	Mail Merge	1	11-01-2016 06:11 PM
Right Justify Values in a Mail Merge	hadenp	Mail Merge	7	12-31-2013 07:40 PM
Prevent Zero Values being Suppressed in a Mail Merge	HangMan	Mail Merge	2	12-11-2013 02:28 PM
showing results of If statements in a mail merge	m&co	Mail Merge	3	01-06-2012 07:27 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:16 PM.