This may be an easier task using VBA and a Case statement.

http://www.ozgrid.com/VBA/select-case.htm



"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)))))