Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #9  
Old 01-07-2019, 06:48 AM
Charles Kenyon Charles Kenyon is offline How make IF Formula return a numbers joined with a letter Windows 10 How make IF Formula return a numbers joined with a letter Office 2016
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

Quote:
Originally Posted by Strogg View Post
The second code worked fine. I simply opened formula dialogue:
Layout-->Formula, then pasted your code there and all worked.
I just can't figure out how to add checking:
if A1 is empty, then show nothing..


Also I tried The first one code, but I must be doing wrong again:
I go to Insert -> Click on Explore Quick Parts -> Field and choose IF field.
Then trying to paste your first code and nothing happens(.

I even trying to toggle field codes in B2 cell and edit directly, but still can't make them working.

To Insert an IF Field:
  1. Type "IF" without the quotation marks and select it.
  2. Press Ctrl+F9
  3. Insert your logical test, your truetext and falsetext


Any time you are having trouble with an IF field check:
  1. What is my logical test?
  2. What is my truetext?
  3. What is my (optional) falsetext?
  4. Note that if you nest fields, all braces must be inserted in pairs by Word, not typed.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I make a slide in PPT return to start page automatically? sawe90 PowerPoint 1 09-15-2018 12:56 PM
How make IF Formula return a numbers joined with a letter make single letter top to bottom of page-Large famreeks Word 3 04-27-2017 05:40 PM
Substring to return numbers funkyfido Excel 4 07-22-2016 10:03 AM
How make IF Formula return a numbers joined with a letter How to make MATCH/INDEX formula return multiple successive responses. danigirl121 Excel 7 06-08-2016 01:57 PM
Words joined - how do i split? speaking Word 4 08-29-2011 12:24 PM

Other Forums: Access Forums

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