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?

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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