If I4 will contain only Y or N, you can do simply:

=if(J4="y","R","")

However, if you want to bullet-proof things, you can do:

=if(and(J4="y",or(I4="y",I4="n")),"R","")

Note: You do not mention what W4 should be if the condition for "R" is not
met. I have arbitrarily chosen a null string, which appears blank.


----- original message -----

"Frustrated!!!" wrote in message
...
My name says it all!!
In Excel 2003 I am trying to get a third result from 2 other Y/N results.
What I need is:

Cell W4 needs to be R if:
I4 and J4 = Y
or
I4 = N and J4 = Y

I have tried other avenues and I'm hoping someone here can help.