+ Reply to Thread
Results 1 to 7 of 7

Calculate invoice discount based on repetitive value.

  1. #1
    Registered User
    Join Date
    12-26-2012
    Location
    Finland
    MS-Off Ver
    Excel 2010
    Posts
    15

    Smile Calculate invoice discount based on repetitive value.

    Hi there,


    I want to make invoice which will calculate total based on discount circumstances. Invoice is meant for translation service.

    I want to calculate special offer. The offer stands for translation service more than five pages per order, has every sixth page for free.

    Every page is let's say 250 words. Word count is located in B2. Subtotal is located in E6 and Discount cell is located in E8.

    All we know that every 5 page is 250*5 which equals 1250.
    Is it possible to calculate discount based on these values, I really cannot understand how to calculate this or is it even possible.

    Thank You for answering!


    Oid83Vn.png

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    5,845

    Re: Calculate invoice discount based on repetitive value.

    Maybe
    =INT(C2/6)*250*D2

  3. #3
    Forum Expert Josť Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Calculate invoice discount based on repetitive value.

    Hi

    I suppose you want this
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    or, in terms of Excel range
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    See the file for clarification
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    12-26-2012
    Location
    Finland
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: Calculate invoice discount based on repetitive value.

    Hey, thank you for your answer

    I tested the formula. The Discount should be 0 if Word Qty is below 1250, currently it show 59,94.

    Also, discount should be calculated only every "5 page" cycle not continuously as i wrote. You get it?


    Thanks again.
    Last edited by dana26; 06-21-2019 at 02:15 AM.

  5. #5
    Forum Expert Josť Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Calculate invoice discount based on repetitive value.

    Hi

    Sorry for the mistake!

    Try this
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Or
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    12-26-2012
    Location
    Finland
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: Calculate invoice discount based on repetitive value.

    Hey,

    Thanks for reply.

    Have you tried this yourself? Because i am getting an error with the first formula. The second formula have no error but still is not correct.

    Please review with the file you sent.

    Thank You so much!

  7. #7
    Forum Expert Josť Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Calculate invoice discount based on repetitive value.

    Hi

    I suppose this now works.
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    See the file
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to calculate avg rate based on repetitive products?
    By Afsheen in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 08-23-2018, 11:52 PM
  2. How to calculate avg rate based on repetitive products?
    By Afsheen in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-14-2018, 07:04 AM
  3. [SOLVED] Calculate time to do a repetitive task
    By Hood in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-16-2018, 06:56 PM
  4. How to calculate discount in PowerPivot??
    By mrxlsx in forum Excel General
    Replies: 1
    Last Post: 06-13-2015, 12:16 AM
  5. Macro to calculate discount
    By amarjeet.it in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-22-2013, 08:55 AM
  6. Replies: 2
    Last Post: 12-21-2012, 04:33 AM
  7. Replies: 5
    Last Post: 01-02-2011, 11:06 PM

Tags for this Thread

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