SOLVED

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

 

steevjp_0-1640345638893.png

 

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

Hi Hans

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

Steve