Using IF to return 1 or 0 for a range of cells

[MarkCunny]

I'm a novice and using =IF(A2="a",1,0) in order to return '1' if 'a' is found in cell A2 or '0' if 'a' is not found in A2. How can I get it to return '1' or '0' if 'a' is found in either of the cells A2 to C2? I wrongly thought =IF(A2:C2="a",1,0) would do the trick but seems I'm wrong, thanks

[AliGW]

Welcome to the forum.

Try this:

=VALUE(COUNTIF(A1:C1,"a")>0)

[MarkCunny]

Excellent Ali, thanks - you set me on the right path. It returned an error so I had to tweak slightly to this: =VALUE(COUNTIF(A2:C2,"a"))

Appreciated!

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

[MarkCunny]

Well I thought that worked until I came across this situation for which it didn't work:

The formula doesn't work if the respondent has answered the same way to 2 or 3 parts of a question. I only need it to return '1' for each part instead of summing the responses.
Difficult to explain so I've attached a section of the sheet. The responses are coded 'a' to 'f' (strongly agree to Don't know) and there are 3 parts to the question
so some respondents will have responded e.g. strongly agree to 2 parts of the question so the formula is going to return 2.

[MarkCunny]

No problem, I think I've sorted my problem with a simple IF formula
Thanks again