=if(And(DG192=1,DG192<=5),if(,T2<=7.4),Indirect(" C"&DG192+2),"What??"),"")

--
Regards,
Tom Ogilvy


"Shu of AZ" wrote in message
...
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)))))