I can't seem to figure out what's wrong with this function. It either says that there are missing parentheses or too many arguments. Could someone lend a hand?
=IF(AND(G3="",C2>=F2),H3+M2-(L2*Variables!B$2+Variables!B$7)+J2,IF(AND(G3=1,D2>F2),(I3+((M2-L2*Variables!B$2)/(B2-Variables!B$8)))*E2)+J2,IF(AND(G3=1,D2<=F2),((H3-J3)/E2)*(MIN(B2,F2)-Variables!B$8)+M2+J3-(L2*Variables!B$2+Variables!B$7),IF(AND(G3="",C2<F2),H3+M2-L2*Variables!B$2,"ERROR"))
Cheers,
Eric
Bookmarks