98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Embedded IF Formula
Embedded IF Formula
Resolved · Low Priority · Version 2007
Fri 25 May 2012, 17:48Delegate Jessica said...
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)))
Tue 29 May 2012, 13:51Trainer Simon said...
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
Thu 31 May 2012, 10:54Delegate Jessica said...
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)))))
Mon 11 Jun 2012, 13:54Trainer Simon said...
RE: Embedded IF Formula
Hi Jessica,
Thank you for the update.
I am glad I helped you solve the formula.
Regards Simon
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Transpose textYou can transpose any range of cells, turning the columns into rows and the rows into columns. Just follow these steps: |
