Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Referencing cells text output if it meets specific conditions
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 |
#2
|
|||
|
|||
Hi Chersie
one method (but i'm sure there's a better way) =IF(ISTEXT(B24),B24,IF(ISTEXT(C24),C24,IF(ISTEXT(D 24),D24,"all false"))) with your three cells being B24, C24, D24 -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Chersie" wrote in message ... 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 |
#3
|
|||
|
|||
Thanks so much JulieD! I figured out another way to do it but I like yours
better! Thanks for the insight!!! "JulieD" wrote: Hi Chersie one method (but i'm sure there's a better way) =IF(ISTEXT(B24),B24,IF(ISTEXT(C24),C24,IF(ISTEXT(D 24),D24,"all false"))) with your three cells being B24, C24, D24 -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Chersie" wrote in message ... 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 |
#4
|
|||
|
|||
you're welcome and thanks for the feedback
"Chersie" wrote in message ... Thanks so much JulieD! I figured out another way to do it but I like yours better! Thanks for the insight!!! "JulieD" wrote: Hi Chersie one method (but i'm sure there's a better way) =IF(ISTEXT(B24),B24,IF(ISTEXT(C24),C24,IF(ISTEXT(D 24),D24,"all false"))) with your three cells being B24, C24, D24 -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Chersie" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort or Filter option? | Excel Worksheet Functions | |||
Locate and delete specific cells | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
How do I get merged cells to display all text. | Excel Discussion (Misc queries) | |||
Sum of specific cells | Excel Worksheet Functions |