How make IF Formula return a numbers joined with a letter

Charles Kenyon · #1 01-07-2019, 06:48 AM

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.

Strogg · #2 01-07-2019, 09:55 AM

Quote:

Originally Posted by Charles Kenyon

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

Great! Thank you guys so much for your help and hints! Finally it works!
I even added check empty cell condition:

Code:

{IF{=A1}= 330 "33x26x20" {IF{=A1}= 250 "25x22x15"{IF{=A1}= 0 "" "39x26x25"}}}

(Sample attached).

But I assume that all of this will take too much time for everyday routine.
So I'd rather go using insert formula with Macropod's second code:

Code:

=A1-250 \# "'33x26x20'; '39x26x25';'25x22x15'"

Could the check of empty cell be added here as well?

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