Excel Formula Advice

New Contributor

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 Replies
best response confirmed by steevjp (New Contributor)


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

A possible formula in H4 would be


This can be filled down.

Hi Hans

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