Solved IF range contains a certain text return text

May 27, 2011 at 13:47:18
Specs: Windows XP
I would like to have a cell display the text "Portfolio Mismatch" if a cell range contains the word FALSE. If all cells in the range contain only TRUE the the cell should display the text "Portfolio Match". The true and false references are based of an exact function between two adjacent columns. The formula works if the logical test is based off of one cell but fails to work when i input a range. I have pasted the formula below for what i would like to achieve.

=IF(L5:L47=FALSE,"Portfolios Mismatched","Portfolios Matched")

See More: IF range contains a certain text return text

Report •

May 27, 2011 at 16:13:20
✔ Best Answer

=IF(COUNTIF(L5:L47,"FALSE"),"Portfolios Mismatched","Portfolios Matched")


Report •

May 28, 2011 at 18:14:09
Worked seamlessly. Thank you very much.

Report •

Related Solutions

Ask Question