Results 1 to 10 of 10

Thread: Formula for phased costs

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Seeker sblondon's Avatar
    Join Date
    Dec 2021
    Excel Version
    office 365 v2102

    Unhappy Formula for phased costs


    I need help creating a formula to work out the service cost for number of vehicles added each month, similar spreadsheet for other types of costs e.g MOT, tyres etc requiring different period start and interval. The current spreadsheet requires the formulas to be manually edited if the interval changes.

    The current spreadsheet:

    • Column A = Month (1-60)
    • Column B = Number of cars added in the month
    • Columns C to BJ = Month (1-60)
    • Row 64 = Totals for each month
    • Cell D1 = Average service cost per vehicle
    • Cell D2 = 1st period service is required after purchase of first vehicles
    • Cell D4 = Service interval e.g. every 4 months

    I need help with creating a formula that will automatically spread the cost based on the intervals and number of vehicles purchased for the period.

    Thank you
    Attached Files Attached Files

Posting Permissions

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