Thread: [Solved] How make IF Formula return a numbers joined with a letter
View Single Post
 
Old 01-06-2019, 12:26 PM
Strogg Strogg is offline Windows 7 32bit Office 2016
Novice
  
Join Date: Jan 2019
Posts: 9
Strogg is on a distinguished road
Default How make IF Formula return a numbers joined with a letter
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?
Reply With Quote