Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page IF Statements for a several ranges of values using Mail Merge IF Statements for a several ranges of values using Mail Merge
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 05-01-2019, 08:42 PM
gmayor's Avatar
gmayor gmayor is offline IF Statements for a several ranges of values using Mail Merge Windows 10 IF Statements for a several ranges of values using Mail Merge Office 2016
Expert
  
Join Date: Aug 2014
Posts: 4,142
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default
Your syntax is wrong - change to
{IF {MERGEFIELD PriorityScore } >= 15 "Very High" "{IF {MERGEFIELD PriorityScore } >= 10 "High" "{IF {MERGEFIELD PriorityScore } >= 5 "Medium" "{IF {MERGEFIELD PriorityScore } >= 1 "Low"}"}"}"}


which does work.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
Reply

Tags
conditional, formula, range

« Previous Thread | Next Thread »


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
IF Statements for a several ranges of values using Mail Merge Using multiple IF statements on a mail merge ajh19742000 Mail Merge 1 11-01-2016 06:11 PM
IF Statements for a several ranges of values using Mail Merge 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
IF Statements for a several ranges of values using Mail Merge 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:30 PM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft