How To Calculate Rental Cost With Varying Rates Based On Rental Days In Excel?

i rent stuff and I charge rent on them based on how many days they have been used. example rates are as follows:
day 1 to 10 = $0
day 11 to 30 = $2
day 31 on wards = $4
how do I make a formula in excel to calculate the rent for say 58 days based on the above rates?
Asked Jul 07, 2017

TIP: If it's not your answer to this question, please click "Leave a Comment" button under the question to communicate with the question owner.