Results 1 to 8 of 8

Calculation Based on Date Criteria

Threaded View

Mgc26133 Calculation Based on Date... 12-14-2018, 08:09 AM
Sam Capricci Re: Calculation Based on Date... 12-14-2018, 08:52 AM
kvsrinivasamurthy Re: Calculation Based on Date... 12-14-2018, 09:55 AM
Mgc26133 Re: Calculation Based on Date... 12-14-2018, 03:03 PM
bebo021999 Re: Calculation Based on Date... 12-14-2018, 11:00 PM
kvsrinivasamurthy Re: Calculation Based on Date... 12-15-2018, 03:08 AM
Bo_Ry Re: Calculation Based on Date... 12-15-2018, 05:20 AM
Mgc26133 Re: Calculation Based on Date... 12-15-2018, 10:53 AM
  1. #1
    Registered User
    Join Date
    11-13-2018
    Location
    Istanbul
    MS-Off Ver
    Microsoft 365
    Posts
    97

    Calculation Based on Date Criteria

    Hello. Before I ask the question, let me explain this. In our country, when we receive traffic fines, if we pay it within 15 days, we receive a 25% discount. If the payment is later than 15 days, we have until 1 month after we are notified to pay the full amount. After 1 month, for each month we don't pay the fine, we get +5% surcharge.

    I created a formula that makes this calculation based on the payment date I would enter. However, it's very long and might force the computer unnecessarily when applied to an entire column (we receive about 100 each month, so there is a lot of rows). I attach a sample excel in which I added the formula for you to check it out. I was wondering if there might be a way to simplify it, make it shorter and more practical.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA calculation based on month criteria
    By robert989 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-30-2016, 09:56 PM
  2. [SOLVED] Percentage calculation based on multiple date criteria
    By odahilys in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-26-2015, 10:10 AM
  3. Trying to create calculation based on particular criteria
    By dwhite30518 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-30-2014, 03:49 PM
  4. Calculation based on a criteria
    By hoosier5 in forum Excel General
    Replies: 3
    Last Post: 10-25-2011, 10:40 AM
  5. Criteria based calculation help.
    By rosarionyc in forum Excel General
    Replies: 18
    Last Post: 11-19-2010, 05:49 PM
  6. Average Calculation based on criteria
    By Grandma8 in forum Excel General
    Replies: 4
    Last Post: 07-14-2010, 12:41 PM
  7. Date Calculation According to the Given Criteria
    By earthworm in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-19-2009, 02:46 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1