How do I use IF formula for multiple cells

[Trey88]

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

[judgeh59]

will this work for you?.....put this in Cell A2 and copy it down

Please Login or Register  to view this content.

[martindwilson]

not sure what you mean by (A2,A8,A9,A23,A27)
but to check each row for any variance
=IF(COUNTIF(B2:F2,"y"),"y","")

[Trey88]

That worked brilliantly. You get may *'s added.

[arlu1201]

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.