# Solved: Excel Formula

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

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.

#### Ent

Josiah

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

Moderator

#### Ent

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

THANK YOU! It works perfectly!

#### Ent

Josiah
You're quite welcome.

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

As Seen On