Results 1 to 6 of 6

Need help in creating a fake discount calculator

Threaded View

  1. #1
    Registered User
    Join Date
    11-09-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2010, 365
    Posts
    3

    Question Need help in creating a fake discount calculator

    I'm very new to excel, my boss request me to create a discount calculator. A cost of price is given. We have a fix discount rate of 5% of that cost value. Some new customer want more percent of discount to the item they purchase. To deal with that, a markup price will be quoted then we will make a discount according to what the customer prefer but the final discounted value will be always be the discounted 5% of our cost value. I've problem creating it because as example; the customer request for 15% discount, when I add the cost + 10% then minus it back to 15%, the value I get will no be the same of the fixed reduced 5% value of my cost value. Please have a look on the image and help me with the formula. Thank you.

    ac16xpZ.jpg
    Last edited by ssneoh; 11-09-2013 at 07:52 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Help Creating a Dutching Calculator
    By djt in forum Excel General
    Replies: 4
    Last Post: 08-17-2014, 04:25 PM
  2. [SOLVED] How to create marks to be used as fake ticks in a fake axis
    By simone77 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-06-2012, 11:44 AM
  3. Creating a GPA calculator
    By lesoies in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-19-2012, 04:01 AM
  4. Help with Creating a Tax Calculator
    By Tabitha1961 in forum Excel General
    Replies: 1
    Last Post: 12-15-2011, 08:36 PM
  5. Creating a better calculator
    By MajorPayne in forum Excel General
    Replies: 4
    Last Post: 02-02-2011, 04: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1