I think it's a nested If statement....

Hi All,

I'm looking for some help in putting together a nested If statement (I think)

If I have a sheet with columns laid out as follows:

Each Row in Cols A B and C have dropdown choices of Y,N or N/A

In Col D I would like to see Pass, Fail or Error depending on the values of Cols A B and C based on:

Y Y Y = Pass
Y N/A Y = Pass
Y N/A N = Fail
Y N N = Fail
N N N = Fail
Y N Y = Error.

I've tried applying values of 1,2 and 3 to each of the Y,N and N/A and then totalling those numbers to then apply a formula like

=IF(D1<5,"Pass",IF(D1=5,"Error",IF(D1>=5,"Fail")))

But I'm getting myself tangled up in what I think should be quite a simple question

Many thanks for any help

Seamus

Using a lookup table maybe.

Dom

Excellent Dom - just what I was looking for

Seamus