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.
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Blank cells: ISBLANK = FALSE, ISTEXT = TRUE 3
Blank cells, or not. 9
Multiple functions 2
If a cell = TRUE how do I get the cell to do a sum function 4
How to get string to use IF formula only when another cell is text 2
How can I nest ISTEXT and IF functions? 1
Format>Cells>Number>Text is very tricky! 6
Blank cell not really blank 10

Top