I have made a spreadsheet that returns values from 3 sets of data each to their own cell. Two of these cells will return “FALSE” and only one of these fields will have a valid text response. How can I consolidate the only valid response of these cells into a fourth cell? (Example: BR2944 returns “FALSE”; BS2944 returns “FALSE”; BT2944 returns text. I would like BU2944 to ‘look at’ these three previous cells and only display the valid text (i.e. not a number) response [i.e. not “FALSE”])
Thank you
