Display R, A or G depending on text in 2 other cells

Hi I am trying to nest a formula with IF & AND to work out a RAG status. I have 2 questions per row (in Columns I:J) which will be answered either Yes or No.
For each combination I need to give a RAG status in Column K – e.g. two Yes replies give Green, 2 No replies give no and one No out of 2 will give Amber

Please could anyone help me out with the syntax as I am getting myself tied up in knots!

Many thanks in advance

Below is hoped for response in Column K:

ColI---Col--- JCol K
Q1----Q2----RAG
Yes---Yes---G
Yes---No----A
No----Yes---A
No----No----R

I tested this and it works. I put this in cell K3.

Please Login or Register  to view this content.

hope this is what you were looking for.

here's one to cover listed possibilities

=MID("RAG",(I2="yes")+(J2="yes")+1,1)