Rounding from multiples

I am trying to get a more accurate rate for rental equipment. Right now I have a drop down list of equipment, and depending on what I choose it selects the appropriate rate per hour and mutliplies by how many hours I have determined are needed. But the stuff I rent goes by days, weeks and months. For example a shovel is $1/day, $3/week and $9/month or a Rake is $2/day, $6/week and $10/month. How do I get the cost to round up to the appropriate cost, depending on the piece of equipment. I only associate 1 piece of equipment per task, so should I use some sort of table that is hour dependent or something else. I'm kinda stumped on this one. Any help is greatly appreciated. Thanks in advance

Wow you raised some really good questions. The way it works is that 1 day is always the minimum. 3 days is always the same as a week. And 3 weeks is always the same as a month. I used the rake and shovels just for some random numbers. But most likely it would be something like this.


Equipment 1day 1week 1month

Rake $25 $75 $225
Shovel $280 $840 $2520

and so on. There are variations, but for the most part its pretty close to that. I dont set the rate, I'm trying to set this up so its easier for me to calculate equipment costs based on the man hours. Like if I know a guy has to dig a hole, and it will take him 10 hours to dig the hole, i need 2 rental days on a shovel. I have a drop down list with all the equipment and the task hours are associated. So another box uses sumproduct from a table I created using (approximate hourly rate) x (hours) but I think this new way will be more accurate. I kinda have a way to figure how many months, weeks and days, but its about 8 boxes big nd uses a lot of either =IF(>=) and =MOD for remainders, but i have to imagine there is an easier way, I'm just not skilled enough. Sorry for the wall of text Thanks in advance.

hehe as a side problem now, I cant get the last digit to round up to the nearest 8. So if the number is between 0 and 8 its 8, 8.1-16 its 16, 16.1-24 its 24, and so on. I just need it to round up by multiples and I messed around with mround cause I need it to always round up, but I couldnt get that to work.

The formula you are looking for is (with your hours in A1):

=CEILING(A1,8)

Sorry for not answering your original problem yet. Do you still need help ?
I have not forgot you, just been busy looking for a new job the last days.