Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

# Thread: Formula to work out price after discount

1. I agreed to these rules
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. Member
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. Long Term Member
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. I agreed to these rules
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

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

#### 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