Solved: Excel Formula

Not open for further replies.

Joined:
Dec 1, 2011
Messages:
3
I need an excel formula that calculates rental rates at \$82 per day for the first 90, \$61.50 per day for next 90 days, and \$45.10 per day thereafter. I have an IF statement that will calculate the first 2 rates. I just don't know how to add the third.

Any help would be greatly appreciated.

Joined:
Apr 11, 2009
Messages:
5,467
First Name:
Josiah

Joined:
Dec 1, 2011
Messages:
3
=IF(B15>90,7380+((B15-90)*61.5),B15*82) - This takes care of the first 2 parts of the equation. I just don't know how to do the third part.

4. valisModerator

Joined:
Sep 24, 2004
Messages:
77,773

Joined:
Apr 11, 2009
Messages:
5,467
First Name:
Josiah
Well, you're almost there already. Use two if statements one inside the other. The first checks whether it is more than 180. If so it uses a similar equation to yours. If less than 180 it goes to your function to find out whether it's between 90 and 180.

=IF(B15>180,12915+((B15-180)*45.10),IF(B15>90,7380+((B15-90)*61.5),B15*82))

Joined:
Dec 1, 2011
Messages:
3
THANK YOU! It works perfectly!

Joined:
Apr 11, 2009
Messages:
5,467
First Name:
Josiah
You're quite welcome.

As Seen On