Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: Formula to work out price after discount

  1. #1
    Join Date
    5th May 2005
    Posts
    4

    Formula to work out price after discount

    Hi,
    Need help with an excel formula to work out cost price for an item after applying a discount. I am only new to this so if anyone can help it would be much appriciated.
    I have following cells which have the data I need to look at to get final cost.
    E10 - Has cost price per meter before discount
    D10 - Has size in meters of lenth of metal
    F10 - Has discount figure (46%)
    G16 - Is where I want discounted price to appear.
    (I need a formula to multiply cost price x size of length of metal, minus the discount figure).

    Tks Mike

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    15th February 2005
    Posts
    50

    Re: Formula to work out price after discount

    here is 1

    =(D10*E10)*(1-F10)

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    25th January 2003
    Location
    Scotland
    Posts
    1,462

    Re: Formula to work out price after discount

    Hi Tks Mike,

    =D10*E10*(1-F10) should give you the Discounted figure

    Regards,

    Bill

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    5th May 2005
    Posts
    4

    Re: Formula to work out price after discount

    Thanks for the help much appreciated.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Building A Formula To Increase Price List 8%
    By Kevin1962 in forum EXCEL HELP
    Replies: 2
    Last Post: September 27th, 2006, 02:58
  2. Small Business Formula for Price List
    By homepcsolutions in forum EXCEL HELP
    Replies: 7
    Last Post: July 21st, 2006, 16:19
  3. Replies: 10
    Last Post: April 25th, 2006, 05:34
  4. Replies: 2
    Last Post: March 17th, 2005, 04:30
  5. Formula for price comparisons
    By inktec in forum EXCEL HELP
    Replies: 7
    Last Post: July 29th, 2004, 00:31

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
  •  
porno