genzedu777 Posted October 19, 2012 Share Posted October 19, 2012 Hi all, I need help in setting multiple if commands in microsoft excel 2010. However after setting more than 2 IF commands, the system prompted me Tiers Equation Interest Rate 1st 20k Next 20k (20 - 40) Next 20k (40 - 60) Next 20k (60 - 80) More than 80k 1st 20k 20000 0.006 ADD INTEREST Next 20k 20001 40000 0.006 $ 120.00 ADD INTEREST Next 20k 40001 60000 0.005 $ 120.00 $ 100.00 ADD INTEREST Next 20k 60001 80000 0.005 $ 120.00 $ 100.00 $ 100.00 ADD INTEREST 80001 777494 0.005 $ 120.00 $ 100.00 $ 100.00 $ 100.00 ADD INTEREST Unlimited 777494 $3,818.189 Code =IF(D17<$B$5,(D17*$D$5),IF(AND(D17>=B6, D17<=C6),(((D17-20000)*D6)+E6))IF(AND(D17>=B6, D17<=C6),(((D17-20000)*D6)+E6))) "You have entered too many arguments for this function. To get help with this function, click OK to close this message. Then click the Insert Function button located to the left of the equal sign in your formula" And I seriously do not know how to use the Function command. It is unlike excel 2003, where it allows multiple IF commands. Need help here. Thanks Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.