01-07-2019, 06:48 AM
|
Moderator
|
|
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,083
|
|
Quote:
Originally Posted by Strogg
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:
- Type "IF" without the quotation marks and select it.
- Press Ctrl+F9
- Insert your logical test, your truetext and falsetext
Any time you are having trouble with an IF field check:
- What is my logical test?
- What is my truetext?
- What is my (optional) falsetext?
- Note that if you nest fields, all braces must be inserted in pairs by Word, not typed.
|