You're Welcome... But the formula provided by Jacob Sir is looks simple and
Great one...

--------------------
(Ms-Exl-Learner)
--------------------



"Zakynthos" wrote:

That's great, worked perfectly - thank you very much - you've saved me a
headache!!!

"Ms-Exl-Learner" wrote:

Use this formula in T1 Cell...

=IF(AND((R1=9),(S1=36)),4,IF(AND((R1=7),(S1=36)),5 ,IF(AND((R1=6),(S1=30)),5,IF(AND((R1=5),(S1=25)),5 ,IF(AND((R1=6.25),(S1=25)),4,IF(AND((R1=5),(S1=20) ),4,IF(AND((R1=4),(S1=20)),5,"")))))))

Now copy the T1 cell formula and apply it for the remaining cells.

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"Zakynthos" wrote:

What would be the format of the IF/AND/OR nested statement to return the
following:


If R1 contains a 9 and S1 contains a 36 I want a 4 in T1

If R1 contains a 7 and S1 contains a 36 I want a 5 in T1

If R1 contains a 6 and S1 contains a 30 I want a 5 in T1

If R1 contains a 5 and S1 contains a 25 I want a 5 in T1

If R1 contains a 6.25 and S1 contains a 25 I want a 4 in T1

If R1 contains a 5 and S1 contains a 20 I want a 4 in T1

If R1 contains a 4 and S1 contains a 20 I want a 5 in T1

Many thanks for your help