Forum Discussion
Concatenating arguments with the IF function
I'm using MS Excel 2016 (part of Office Professional Plus 2016) I have following spreadsheet. ID plan1 plan2 plan3 plan4 plan5 plan6 Result 12345 BH1 DoNothing BH3 DoNothing Do...
Detlef_Lewin Thank you so much Detlef. This worked perfectly. I wasn't aware of the TEXTJOIN function and didn't see it with all of my web searches. I'll keep it handy.
