How make IF Formula return a numbers joined with a letter

Strogg · #10 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