Results 1 to 20 of 20

Formula that identifies best rate and cost based on number of days

Threaded View

  1. 11-06-2015, 04:59 PM #1
    madrick1991
    madrick1991 is offline
    Registered User
    Join Date
    11-06-2015
    Location
    Florida
    MS-Off Ver
    2010
    Posts
    10

    Formula that identifies best rate and cost based on number of days

    Hello All,

    I'm looking for a formula that can help the user of the spreadsheet plug in the number of days a piece of equipment needs to be rented and determine the best cost. The issue is that there are 3 different rates: Daily, Weekly and Monthly. Attached is the spreadsheet. Is there anyway to do what I'm asking?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula Needed to Calc Total Cost for Using Equipment when Rate Increases per Days Used
    By Mollylou85 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-06-2015, 01:41 PM
  2. How to calculate number of sick days taken in a rolling 365 days period based on colour
    By shazzm in forum Excel General
    Replies: 0
    Last Post: 06-11-2015, 03:12 AM
  3. Formula to distribute number across several days based on predefined percentages
    By friedgoldmole in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-09-2015, 05:41 PM
  4. Formula that takes a simple interest rate and adjusted for origination cost up or down
    By curtinch in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-25-2014, 03:04 PM
  5. Excel formula that identifies the next number in the series.
    By crazysniper in forum Excel General
    Replies: 3
    Last Post: 03-07-2012, 07:09 PM
  6. cost based on number of units where cost changes
    By jbowling in forum Excel General
    Replies: 3
    Last Post: 08-22-2011, 02:36 PM
  7. Formula help considering cost and success rate
    By BeatBama in forum Excel General
    Replies: 2
    Last Post: 03-03-2011, 01:17 PM

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1