It might be clearer if you throw away a heap of unnecessary parentheses.

You can simplify it from
=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,"")))))))
to
=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 ,"")))))))
--
David Biddulph

"Ms-Exl-Learner" wrote in message
...
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