Hi! Again! You guys are so helpful I have to ask this question because I know you will be able to help me!

I have three rental prices. a 1 day rental costs 700
a 1 week rental costs 1900
a 4 week rental costs 5500

I have a certain number of days ill need the rental which varies per project.
I would LOVE for excel to make sure i have the correct number of days required covered at the cheapest cost.

at first I was using if the number of days is less than 3 then use (2) "day" rentals since if i had 3 days it would be cheaper to just buy a week. and that worked but then when i got to one week my formula was waaay to long and not even correct.

the only catch (and im not sure that it is) is that we can only use the rental for the 5 work days in a week.

I hope this is enough information if anyone could give me a place to start, or link to another page that would be able to help me, it would be great!