View Single Post
 
Old 01-07-2019, 06:48 AM
Charles Kenyon Charles Kenyon is offline Windows 10 Office 2016
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,083
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