# Pull Down boxes and Tables

1. ## Pull Down boxes and Tables

OK, thanks to you guys I am nearly done with my project. Here goes the last part. I have a list of items in a drop down box, about 8 of them and they each have a different daily, weekly and monthly rate. Normally 3 days is the same cost as a week, and 3 weeks is the same as a month. Now thanks to you guys I have a table of about 7 cells that all I do is input the man hours, and it gives me how many months, weeks and days of rental charge there will be. How do I make it so a cell will reference the drop down box, use the correct price info for that particular equipment, the hours another cell says are needed and use the month/week/day calculater to make the right price. I have 2 cells open horizontal to each other if that helps. I was thinking maybe a different chart for each equipment using =sumproduct, but im not sure if that can be done, or if there is an easier way. Again, any help is GREATLY apreciated. Thanks in advance.

ps ill give an example. shovel cost- \$30/day \$90/week \$270/month
hole digging will take 215 hours, so I need the shovel for 1 month, 1 week and 2 days. so the cost will be 270 + 90+ 60 = \$420

2. Wow, at those prices you must work for the U.S. Government. How much do toilet seats and hammers go for?

3. LOL, I was just throwing numbers out there to illustrate the pricing pattern.

4. Do you have a copy of your spreadsheet you can zip up and post? I'm assuming someone else helped you previously, so I'm not familiar with the layout you're using.

Thanks.

5. I had mostly gotten help with the month week day calculater. The rest is a company thing I've been trying to make better. I cant show you the main page, but Ill see about zipping the "data" page where I keep the tables and stuff.

EDIT: Attached part of my form I use

6. Ok here is what I came up with. It seems kinda sloppy, and ill have to do a month/week/day calulater for every row (about 100) but that was the easiest way I could figure it out. Is there a way to make the calculater one cell maybe? I dont know, but any help awesome, my brain is fried. Ill check back tomorrow.BTW thanks for the help Pjaoquin, you are awesome man.

7. Sorry I couldnt get back to the office for a couple days. So no one was able to crunch down the month/week/day calculater some how? If I could get it to just one cell instead of 11, that would be the answer to all my problems. I was thinking, maybe I would turn each column of the "calculater" to a named formula ( I thought I read something on that), and then a single cell would reference all 3 named formulas and turn that into three numbers seperated by commas, then the cost can use some sort of seperator to use the 3 numbers. I'm not sure if thats possible or if it is how to do it.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1