Function that will = 1 of 4 cell containing text
 

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(B A10),BA10,IF(ISTEXT(BA11),BA11,""))))

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

Any other way to do this.


--
jermsalerms
------------------------------------------------------------------------
jermsalerms's Profile: http://www.excelforum.com/member.php...o&userid=30167
View this thread: http://www.excelforum.com/showthread...hreadid=557073

Function that will = 1 of 4 cell containing text
 

Hi,

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

hth
regards from Brazil
Marcelo

"jermsalerms" escreveu:


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(B A10),BA10,IF(ISTEXT(BA11),BA11,""))))

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

Any other way to do this.


--
jermsalerms
------------------------------------------------------------------------
jermsalerms's Profile: http://www.excelforum.com/member.php...o&userid=30167
View this thread: http://www.excelforum.com/showthread...hreadid=557073

Function that will = 1 of 4 cell containing text
 

=concatenate(ba8,ba9,ba10,ba11)

Hth


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=557073

Function that will = 1 of 4 cell containing text
 

The cells do result in "" if they are false

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


--
jermsalerms
------------------------------------------------------------------------
jermsalerms's Profile: http://www.excelforum.com/member.php...o&userid=30167
View this thread: http://www.excelforum.com/showthread...hreadid=557073

Function that will = 1 of 4 cell containing text
 

Did you try the Concatenate?


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=557073

Function that will = 1 of 4 cell containing text
 

Worked like a charm! Thanks!


--
jermsalerms
------------------------------------------------------------------------
jermsalerms's Profile: http://www.excelforum.com/member.php...o&userid=30167
View this thread: http://www.excelforum.com/showthread...hreadid=557073