How do I use an IF formula to check multiple cells and return a true/false answer in another cell
Example
I have multiple cells in a row that contain the letter "Y" to indicate a variance (A2,A8,A9,A23,A27). In cell A1 I would like to add a formula that would check all of the designated cells in ROW 1 and return a "Y" if any of those cells contain the letter "Y".
Thanks for any assistance!Example.xlsx
Bookmarks