Function that will = 1 of 4 cell containing text

J

jermsalerms

I have 4 cells BA8:BA11

Each one contains a if statement that returns text if it is true.
Only one of the 4 can be true and all could be false.

I want BA12 to return the text in the true cell and return "" if all
are false.

I tried this equation and a variation using ISBLANK

=IF(ISTEXT(BA8),BA8,IF(ISTEXT(BA9),BA9,IF(ISTEXT(BA10),BA10,IF(ISTEXT(BA11),BA11,""))))

but it always returns "" even if there is a true result.

Any other way to do this.
 
M

Marcelo

Hi,

notice that "" is text also, if the cells ba8:ba11 return "" too.

hth
regards from Brazil
Marcelo

"jermsalerms" escreveu:
 
J

jermsalerms

The cells do result in "" if they are false

So what is another way to do this...there must be some formula tha
will search BA8:BA11 for text that IS NOT "" and return the text i
that cell
 
Top