How make IF Formula return a numbers joined with a letter

Strogg · #1 01-06-2019, 12:26 PM

Hi Experts,

Almost 3 years have passed since I found nice features of MS Word to use Excel calculations in tables including logical functions. But seems they work only with numbers.
In the table when using IF function is it possible to have returned set of numbers joined with letter like below:
Something like:
=IF(A1=330,"39x33x15",IF(A1=250,"25x23x15",IF(A1=0 ,0,"40x40x25")))
It is obvious that above construction will return syntax error.

Is it possible to make it work somehow?

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