You do not say what happens if your additional values are true.? You could
do a VLOOKUP, and find values based on that. You could also add "NOT DONE"
after C7, before the first ). In a second cell, you then enter the following
IF formula, starting with =IF(<the cell containing the original
formula<"NOT DONE",<original
location,IF(AND(DG192=1,T27.5),result,IF(AND(DG1 92=2,T27.5),result and so
on. I trust that you mean 7.5, and not 7.4, since <7.5 could equal 7.4,
and 7.4 coul equal 7.5?

--
Hth

Kassie Kasselman


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