Microsoft Office Forums Converting a 1 or 0 into TRUE or FALSE?

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-25-2017, 10:08 AM
ayupchap ayupchap is offline Converting a 1 or 0 into TRUE or FALSE? Mac OS X Converting a 1 or 0 into TRUE or FALSE? Office 2013
Novice
Converting a 1 or 0 into TRUE or FALSE?
 
Join Date: Oct 2016
Posts: 6
ayupchap is on a distinguished road
Default Converting a 1 or 0 into TRUE or FALSE?

Hi all



SO I have a mailmeger import which lists a true or false as a 1 or 0, thats expected and toally fine but to make my output mail merge betetr is there a way to set a formula or another method to turn the 1 or 0 into the word TRUE or FALSE (1 = TRYE and 0 = FALSE)

Be great if its possible
Reply With Quote
  #2  
Old 04-25-2017, 02:45 PM
macropod's Avatar
macropod macropod is offline Converting a 1 or 0 into TRUE or FALSE? Windows 7 64bit Converting a 1 or 0 into TRUE or FALSE? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,525
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Sure, you can evaluate a field's content, but you haven't really given us much to go on. Basically, you'd use either an IF field or a Formula field. For example:
{IF{MERGEFIELD MyField}= 1 "Text for True result" "Text for False result"}
or:
{IF«MyField»= 1 "Text for True result" "Text for False result"}
for the conditional display of some text.

Alternatively, you might use:
{={MERGEFIELD MyField}*45+15}
or:
{=«MyField»*45+15}
to display 60 when 'MyField' = 1, 15 when 0.

Note: The field brace pairs (i.e. '{ }') for the above example are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac); you can't simply type them or copy & paste them from this message. Nor is it practical to add them via any of the standard Word dialogues. Likewise, you can't type or copy & paste the chevrons (i.e. '« »') - they're part of the actual mergefields, which you can insert from the 'Insert Merge Field' dropdown. The spaces represented in the field construction are all required.

I suggest you also have a read of the Mailmerge Tips and Tricks 'Sticky' thread at the top of this forum:
https://www.msofficeforums.com/mail-...ps-tricks.html

PS: I note that I've referred you to the Mailmerge Tips and Tricks 'Sticky' thread, and to other resources before: https://www.msofficeforums.com/mail-...-its-even.html
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
True 4:3 background dimensions a_gunslinger PowerPoint 1 11-28-2016 08:22 PM
Converting a 1 or 0 into TRUE or FALSE? Can you do True or False equations in Excel? WisCowboy Excel 1 02-05-2016 04:53 PM
Converting a 1 or 0 into TRUE or FALSE? Task Indicator - All predecessors complete true/false, y/n jdove78 Project 2 10-10-2012 05:53 PM
Converting a 1 or 0 into TRUE or FALSE? Mail Merge Function not Noticing 'True' vs. 'False' Statement danellekent Mail Merge 1 04-27-2012 02:19 AM
Converting a 1 or 0 into TRUE or FALSE? Macro not staying true oluc Word VBA 4 11-21-2010 08:10 AM


All times are GMT -7. The time now is 02:39 PM.


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