I can't thank you enough. I placed another IF statement concerning dg192 and
t2 greater than 7.4 where the "OTHER" result was and its working. Thank you
again

"Teethless mama" wrote:

=IF(AND(T2<7.5,OR(DG193={1,2,3,4,5})),CHOOSE(DG193 ,C3,C4,C5,C6,C7),"OTHER")


"Shu of AZ" wrote:

My dilema is that in the same statement you read below, I have to also ask
also if T27.4 and dg193=1,2,3,4,or 5, but that would be too many IF
statements. Any ideas on how to reduce this statement?


=IF(AND(DG192=1,T2<7.5),C3,IF(AND(DG192=2,T2<7.5), C4,IF(AND(DG192=3,T2<7.5),C5,IF(AND(DG192=4,T2<7.5 ),C6,IF(AND(DG192=5,T2<7.5),C7)))))