=IF(AE196<=8,$Z$275,IF(AE196<=10,$Z$276,IF(AE196<= 12,$Z
$277,IF(AE196<=14,$Z$278,IF(AE196<=16,$Z$279,IF(AE 196<=18,$Z
$280,IF(AE196<=20,$Z$281,IF(AE196<=22,$Z$282,"DEEP "))))))))

AE196 is the depth of the structure

If the depth is less than X, then the trench width will be whatever
Z2XX is.

Unfortunately I cannot do more than 8 IF statements. Is there any
other better alternative to this?

Thanks.