Can anyone decipher or deconstruct these formulas for me? Thanks

[Clarksue]

=IF((E12+F12>0),IF(((E12*12)+F12)>=Summary!L7,ROUNDUP((((E12*12)+F12)-Summary!L7+1),0),0),IF((Summary!L16>0),Summary!L16-Summary!L7+1,0))

=MAX(0,MIN(1,IF(AF12>=0,AF12,IF(Summary!L8>=0,(AK12*Summary!L8),MIN(AS12,1*IF(AG12>=0,(AK12*AG12),IF(AP12>0,AR12,IF(E12+F12=0,AK12*Summary!L14,0))))))))

[tony h]

Many could but not with anything meaningful. I will give you a couple of bits that might help

The IF has the form IF(compare , do_this_if_true , do_this_if_false ) eg IF(A1>5 , "result is greater than 5" , "less than 5" )

and also use the Evaluate Formula function. This is on the formulas tab it looks a bit like a magnifying glass

[protonLeah]

Given: =IF(E12+F12>0,IF((E12*12)+F12>=Summary!L7,ROUNDUP((E12*12)+F12-Summary!L7+1,0),0),IF((Summary!L16>0),Summary!L16-Summary!L7+1,0))

---

1	Test condition	True clause	False Clause
2	E12+F12>0	IF(((E12*12)+F12) >= Summary!L7, ROUNDUP((((E12*12)+F12)-Summary!L7+1),0),0)	IF(Summary!L16>0,Summary!L16-Summary!L7+1,0)
3	This is the condition to test. It evaluates to either TRUE or False and branches to the corresponding clause to evaluate	This is the TRUE (Then) clause of the first IF function. It is also an IF function. Test: is the product of cell E12 X 12 plus cell F12 is greater than or equal to the value on sheet summary cell L7? True (yes), THEN subtract sheet summary cell L7 from it, add 1 and round up the result to zero decimal places False (no), ELSE return 0.	This is the FALSE (Else) clause of the first IF function. It, too, is an IF function: Test: Is value of cell L16 on Summary tab is greater than zero? True (yes), THEN subtract value in cell L7, sheet summary from cell L16 sheet summary and add 1 False (no) ELSE, return zero.

[Pepe Le Mokko]

You also have the "Evaluate Formula" tool

[Clarksue]

I have a mac...