+ Reply to Thread
Results 1 to 3 of 3

Calculate early settlement rebate

  1. 07-15-2019, 10:08 AM #1
    Dotreena
    Dotreena is offline
    Registered User
    Join Date
    01-09-2018
    Location
    West Midlands, England
    MS-Off Ver
    2016
    Posts
    75

    Calculate early settlement rebate

    Does anyone know how to begin working out an early settlement rebate via excel formula?

    The formula for the calculation is below.



    Rebate Formula.png
    Reply With QuoteRegister To Reply
  2. 07-15-2019, 10:20 AM #2
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,846

    Re: Calculate early settlement rebate

    You do realise that you have not responded to the help you received most recently in your last thread, don't you? That help may well help you here, too.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 07-15-2019, 10:27 AM #3
    Dotreena
    Dotreena is offline
    Registered User
    Join Date
    01-09-2018
    Location
    West Midlands, England
    MS-Off Ver
    2016
    Posts
    75

    Re: Calculate early settlement rebate

    Quote Originally Posted by AliGW View Post
    You do realise that you have not responded to the help you received most recently in your last thread, don't you? That help may well help you here, too.
    it's a different equation, I didn't think you could post about 2 different topics in 1 thread?
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. Calculate Invoice Ageing settlement on FIFO basis
    By Hanky in forum Excel General
    Replies: 5
    Last Post: 05-09-2019, 02:57 AM
  2. How to calculate Early, OnTime and Late Deliveries using an expected delivery window
    By MzDingle in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-06-2017, 12:00 PM
  3. Formula to calculate period for investment with daily compounding and monthly settlement
    By Bezzie in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-21-2015, 07:42 AM
  4. Easier way to Calculate # Days Early or Late Between Dates w/NETWORKDAYS formula
    By dburrup in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-10-2013, 05:17 PM
  5. [SOLVED] formular that will calculate number of days late or early
    By SOUT in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-09-2012, 04:49 PM
  6. [SOLVED] Calculate a quantity rebate
    By Sige in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-16-2006, 10:15 AM
  7. How to calculate total interest on 12 month loan with early payments
    By KG in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-08-2005, 04:06 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