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