Ask Your Question
1

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 +0200

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
3

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

JohnSUN gravatar image

One possible solution

{=CONCAT(T(BR2944:BT2944))}

StringIfNotFALSE.png

edit flag offensive delete link more

Comments

That actually did it. Thank you so much!!

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

Question Tools

1 follower

Stats

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

Seen: 45 times

Last updated: May 29 '18