Struggling to combine two IF functions (nesting as it is called).

[passerby08]

Hi All,

Struggling to combine two IF functions (nesting as it is called).

Basically I am trying to evaluate this:

If either P3 or Q3 is "Yes" then X3 should be "Correct" else X3 should be "Wrong".

I am not sure what I am missing:

I tried this: IF( P3="Yes", "Correct", IF( Q3="Yes", "Correct", "Wrong" )).

Please advise

Thanks

Charles

[Pete_UK]

Try it this way in X3:

=IF(OR(P3="Yes",Q3="Yes"),"Correct","Wrong")

Hope this helps.

Pete