Announcement

Collapse
No announcement yet.

Formula to work out price after discount

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

  • #2
    Re: Formula to work out price after discount

    here is 1

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

    Comment


    • #3
      Re: Formula to work out price after discount

      Hi Tks Mike,

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

      Regards,

      Bill

      Comment


      • #4
        Re: Formula to work out price after discount

        Thanks for the help much appreciated.

        Comment

        Working...
        X