I have a formula that works fine, written as:

=IF(AND(MAX(Q10:R10)=1,MID(A10,1,3)="ARU"),2,MAX(Q 10:R10))

My problem, though, is that I want to check cell A10 for other
possibilities besides"ARU". Let's say I also want to check for "CON"
and "TUF". How do I add these other possibilites to the formula? The
OR function has thrown me for a loop!

Thanks, Brendan