Need something other than IF function
On Jul 25, 12:44*pm, "Bob Phillips" wrote:
=IF(AE16<=8,$Z$275,IF(AE1622,"DEEP",INDEX($Z$276: $Z$282,ROUNDUP((AE16-8)/2,0))))
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"PrinceAli" wrote in message
...
=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.
Thank you!
|