Calculating Running Cost based on three diffrent rates
What function/formula would work best for calculating a Daily cost for an item, given a specified rate.
Item 1 Daily Rate: $200 Weekly Rate: $1000 Monthly Rate: $3000 Days on Rent: 23 days
Given the above information how can I break it down to find a current running cost. For 23 days it would be 3 weekly rates ($1000*3) and 2 daily rates ($200*2) for a total of $3400.00.
Paste into E2 and fill down
Formula:
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Thank you very much! I appreciate it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks