Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 03-09-2015, 12:57 PM
Charles Kenyon Charles Kenyon is offline Assistance with Word 2010 If formula Windows 7 64bit Assistance with Word 2010 If formula Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,533
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

If you want to avoid nested IF fields, simply put them one after another:
{ IF {REF One} = "One" "1" "" }{ IF {REF One} = "Two" "2" "" }{ IF {REF One} = "Three" "3" "" }{ IF {REF One} = "Four" "4" "" }

Otherwise, you can put the successive fields inside the quotemarks for the false text.
{ IF {REF One} = "One" "1" "{ IF {REF One} = "Two" "2" "{ IF {REF One} = "Three" "3" "{ IF {REF One} = "Four" "4" "" }" }" }" }
I believe you can go 16 deep.
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Foot Notes assistance talit27 Word 1 02-04-2015 03:08 PM
Assistance with Word 2010 If formula Tools or Assistance in Making a 3D Cube mredmond PowerPoint 4 09-24-2014 06:30 AM
Graph Assistance medavidcook Excel 9 01-31-2014 02:17 AM
Would like some assistance with mirror printing jpalmisano Drawing and Graphics 1 01-08-2014 10:45 AM
Assistance with Word 2010 If formula Formula assistance please blazzercat Excel 2 07-08-2009 08:45 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:46 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