Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-09-2015, 11:48 AM
ciresuark ciresuark is offline Assistance with Word 2010 If formula Windows 7 32bit Assistance with Word 2010 If formula Office 2010 32bit
Novice
Assistance with Word 2010 If formula
 
Join Date: Oct 2014
Posts: 7
ciresuark is on a distinguished road
Default Assistance with Word 2010 If formula

I have a document with a combo box. I would like a result on a different line to populate based on the result of the combo box. I am using an IF statement for my result. My combo box has numbers spelled out (Two, Three, Four). When one is selected a number would appear later in the text.



I know
Code:
{ IF {REF One} = "Two" "2" "" }
works; however, I am unsure of how to add the remaining references to "Three" and "Four".

Thoughts.
Reply With Quote
  #2  
Old 03-09-2015, 12:57 PM
Charles Kenyon Charles Kenyon is online now 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,124
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
Reply

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 06:27 PM.


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