Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 04-23-2014, 02:47 PM
macropod's Avatar
macropod macropod is offline How to setup Nested If statement Windows 7 32bit How to setup Nested If statement Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi bigukfan,

You can't use the * wildcard on both sides of a constant; only before or after. You can use the ? wildcard that way, including in conjuction with the * wildcard on the other side of the constant, but then you have to know exactly how many characters you're dealing with on the ? side of the constant.

There's no particular reason I can see from what you've posted for nested IFs. Using the examples from your first post, you could simply have a sequence of IF fields:
{IF{MERGEFIELD AR}= "never" {MERGEFIELD AR}}{IF{MERGEFIELD AR}= "slight" {MERGEFIELD AR}}{IF{MERGEFIELD AR}= "moderate" {MERGEFIELD AR \* Charformat}}{IF{MERGEFIELD AR}= "severe" {MERGEFIELD AR \* Charformat}}

Nesting is useful where you have multiple conditions that evaluate one way and others that evaluate another way, but you don't want to test them all independently, as per the above, Which could be used thus:
{IF{MERGEFIELD AR}= "never" {MERGEFIELD AR} {IF{MERGEFIELD AR}= "slight" {MERGEFIELD AR} {MERGEFIELD AR \* Charformat}}}
or if the evaluation of one element is dependent on the evaluation of another (but that typically entails evaluating two mergefields to determine the output).
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Nested vlookup with varable tables! Dave Jones Excel 0 08-30-2012 09:15 AM
Heading Styles with Nested Numbering dlowrey Word 3 02-19-2012 06:48 PM
How to setup Nested If statement numbered nested list giocarmine Word 1 01-22-2012 11:19 AM
How to setup Nested If statement Nested IFs JimS378 Excel 7 05-03-2011 08:20 PM
Help with nested cylinders and labels pixmanlajunta PowerPoint 0 01-18-2010 11:25 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:34 PM.


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