Multipe Ifs Command In Microsoft Excel 2010

[genzedu777]

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

[kicken]

I'm not really much of an excel person, but if you take that line of code and tab it out to show how things line up, you can see where you have a problem:

=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)
)
)

 

Your last IF() is not in the correct place. I am assuming you intended to do something like this:

=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)
	)
)
)