Referencing cells text output if it meets specific conditions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have three cells, two of which return "FALSE" depending on the conditions
and one that outputs text. I am trying to then have another cell look at
these three cells and return the text from the cell that is not FALSE.

The third cell can be any of three different statements. What is the
formula to return only the cell information on the one that is not FALSE so
that it will return the same text?

Thank you so much,
Chersie
 
Hi Chersie

one method (but i'm sure there's a better way)

=IF(ISTEXT(B24),B24,IF(ISTEXT(C24),C24,IF(ISTEXT(D24),D24,"all false")))
with your three cells being B24, C24, D24
 
Thanks so much JulieD! I figured out another way to do it but I like yours
better! Thanks for the insight!!!
 
you're welcome and thanks for the feedback

Chersie said:
Thanks so much JulieD! I figured out another way to do it but I like
yours
better! Thanks for the insight!!!
Click to expand...
 
You must log in or register to reply here.

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

conditional formatting - problem with text cell value from formula 2
Searching the formula (not the value) for a text string 1
Combining text from multiple cells 6
IF OR AND in same conditional formula 2
If statement that returns data in a cell if False. 2
Real teaser! 4
return blank cell if condition met 2
IF and AND functions help required 4

Back
Top