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