Deciphering two formulas

[tylerpat7]

=IF(A18="","",IF(T18="X","Ck FinEnd",IF(NOT($S$16="OK"),$S$16,(U18+V18)*(1+J18)+K18)))


=IF(AND(Z18>0,OR($AB$17="SUP",$AB$17="Des")),IF(OR(D18="L",D18="R"),1*C18,IF(D18="B",2*C18,0)),0)

[olasa]

What is the question?

Ola

[tylerpat7]

I need these two formulas translated I cannot figure them out

Thanks

[dfeld71]

=IF(A18="","",IF(T18="X","Ck FinEnd",IF(NOT($S$16="OK"),$S$16,(U18+V18)*(1+J18)+K18)))

If A18 is emplty, then do nothing.
If it is NOT empty, look in cell T18. If T18 has an X, then put "Ck FinEnd" in that cell.
If T18 does NOT have an X, and S16 does NOT say "OK", then leave S16 alone. If S16 DOES say "OK", then make S16 equal to (U18+V18)multiplied by (1+J18+k18)


=IF(AND(Z18>0,OR($AB$17="SUP",$AB$17="Des")),IF(OR(D18="L",D18="R"),1*C18,IF(D18="B",2*C18,0)),0)

I am not sure about this one, as I have never used the AND OR statement. Sorry.