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")

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

MIKE

Worked seamlessly. Thank you very much.

Ask Your Question

Weekly Poll