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.
|