Need formula for setting number ranges to a specific "output"

jlew04

New Member
Joined
Aug 20, 2015
Messages
1
I am working on a proposal guide for my company. We have products rented out to consumers for various amounts of time.
Right now I am using a drop down for selecting daily weekly monthly and the user will input the number of days, weeks, months, so forth.

I am looking to write a formula where the user only inputs the amount of days. Eg. 6 or 65. based on the inputed number the formula will generate whether it is daily weekly or monthly.

This is as far as I have gotten with a formula that will work:

=IF(C13<5,"daily",IF(C13<8&C13>4,"weekly","-"))

when I try to add in monthly, it gets all jacked up.

Essentially, I want it to input my number of days "45" have it calculate the the number of daily, weekly and monthly based on 1-4 = daily 5-7=weekly and 21-30 = monthly.
Therefore 45 days would be 1 monthly 2 weekly and 1 daily.

If I can take if further, would be AWESOME, where I could index the equipment based on the 1 monthly, 2 weekly, and 1 daily price to give me a lump sum total of what the job would cost for a 45 day job.

Currently i am using a drop down for my equipment and a drop down for a single daily, weekly, or monthly price and then estimating a daily cost and then manually multiplying it by the 45 for an estimate cost.

=IFERROR(INDEX(Pricing!$A:$I,MATCH(E35,Pricing!$A:$A,0),MATCH(H35,Pricing!$1:$1,0)), " ")

I am not sure how much more information you would need but I am willing to offer it, if it helps. Thanks
Jlew
 

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top