Jessica has attended:
Excel Advanced course
Embedded IF Formula
I have tried using the following formula and excel claims there are too many arguments for this function. This doesn't seem like a particularly long formula, is there any other reason it is saying this other than a limit on IFS?
Should I be using OR?
=IF(I3<N1,0,IF(AND(I3>N1,I3<O1),((I3-N1)/K3)*L3,IF(AND(J3>N1,J3>O1),((O1-N1)/K3)*L3,IF(AND(J3>N1,J3<O1),((J3-N1)/K3)*L3),0)))
RE: Embedded IF Formula
Hi Jessica,
I think I have sorted it. There seemed to be too many brackets.
Let me know how you get on and whether you get the right result.
=IF(I3<N1,0,IF(AND(I3>N1,I3<O1),(I3-N1/K3)*L3,IF(AND(J3>N1,J3>O1),(O1-N1)/K3*L3,IF(AND(J3>N1,J3<O1),(J3-N1)/K3*L3,0))))
Regards
Simon
RE: Embedded IF Formula
Thanks that did help!
Final formula ended up as:
=IF(AND($I3>N$1,$I3>O$1),0,IF(AND($I3<N$1,$J3<N$1),0,IF(AND($I3>N$1,$I3<O$1),((O$1-$I3)/$K3)*$L3,IF(AND($J3>N$1,$J3>O$1),((O$1-N$1)/$K3)*$L3,IF(AND($J3>N$1,$J3<O$1),(($J3-N$1)/$K3)*$L3,0)))))
RE: Embedded IF Formula
Hi Jessica,
Thank you for the update.
I am glad I helped you solve the formula.
Regards Simon
