Excel Formula Advice

[steevjp]

Hi All

I am a novice excel user and I am trying to get a formula to work but am struggling, I think it needs the IF command but again unsure

I have 3 fields, options 1 to 3, a result and then the calculation which will be a Y or an N. The options will be a number between 1 and 6

in the example the option example is 1, 3 and 6. the result is a number that I add manually and doing that will produce a Y (if the number under result = one of the numbers under options 1 to 3) or an N if it doesnt.

Hope that makes sense

[#2 · Accepted solution]

@steevjp 

Let's say the first data row has options in D4:F4 and result in G4.

A possible formula in H4 would be

=IF(COUNTIF(D4:F4,G4),"Y","N")

This can be filled down.

[#3]

Hi Hans

Thanks very much for the quick response, that works beautifiully, thank you

Steve