Hi

=(U13="X")*MAX($L$9,EVEN(E13)*EVEN(I13)/144)+AND(U13<"X,V13="X")*MAX(?,?)+A
ND(U13<"X,V13<"X";?="X")*MAX(?,?)+etc.
or
IF(U13="X",MAX($L$9,EVEN(E13)*EVEN(I13)/144),IF(V13="X",MAX(?,?)+AND(U13<"X
,V13<"X";?="X"),IF(?,?,...)))
(you can nest up to 7 IF's in such way)

Sorry, but your explanations are a mess - it was impossible to understand,
what are conditions after 2nd, and return formulas after 1st. (PS. When
there are common parts in all return formulas, then it is possible to reduce
both formulas above somewhat).

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"Rochelle B" <Rochelle wrote in message
...
I have been fighting this dilema for 3 weeks.
tempred min sft 4($L$9)
annealed min sft 1($L$10)
heatstrengthened min sft 2($L$11)
qty(C13) Width(E13) Height (I13) sft temp(u13)
ann(v13)
ht str(w13)
5 5 5
X

in sft, I need A FORMULA TO
=IF(U13="X",EVEN(E13)*EVEN(I13)/144 at this point I need the formula
to calculate if the product returned is greater than $L$9 (BEING MIN SFT
OF
4) to calculate EVEN(E13)*EVEN(I13)*C13/144, if not true, then return
$L$9)
but if u13 DOES NOT have an X and v13 DOES have an X, then I need to
repeat
the IF formula with using $L$10, and again the same if formula, if $L$10
DOES
NOT have an X and w13 DOES, then it needs to calculate using $L$11.

The bottom line is, that depending on which box has an "X" depends which
boxes to use for calculation. I can get 1 IF function to work with this
but
not three and I can't get it to return the min of 4 sft if the total
product
is less than 4