# Multipe Ifs Command In Microsoft Excel 2010

## Recommended Posts

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 ##### Share on other sites

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

##### Share on other sites

This thread is more than a year old. Are you sure you have something important to add to it?

## Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account. ×   Pasted as rich text.   Restore formatting

Only 75 emoji are allowed.