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