Ask Your Question

How can I create a formula that returns the only valid text from the previous 3 fields in the row? [closed]

asked 2018-05-29 00:22:00 +0100

JaredKenwell gravatar image

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

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by JaredKenwell
close date 2018-05-29 14:44:40.690272

1 Answer

Sort by » oldest newest most voted

answered 2018-05-29 12:25:20 +0100

JohnSUN gravatar image

One possible solution



edit flag offensive delete link more


That actually did it. Thank you so much!!

JaredKenwell gravatar imageJaredKenwell ( 2018-05-29 14:43:02 +0100 )edit

Question Tools

1 follower


Asked: 2018-05-29 00:22:00 +0100

Seen: 70 times

Last updated: May 29 '18