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
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