If/Then Statement in Excel

In Column AS I would like it to say "Yes" if any cell to the left says "5 Miles or Less". It it does not say that anywhere in the row, it will say "No".

If there is the text "5 Miles or Less" in any cell in the row between columns C and Column AR say Yes, if not say "No"
Who is Participating?
NorieVBA ExpertCommented:
Try this in AS2 and copy down if required.

=IF(COUNTIF(C2:AR2, "5 Miles or less"), "Yes", "No")
Just tried same, except changed C:AR2 to A1:E1 for testing purposes.

worked like a charm.
cansevinAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.