Excel Help Please

leftcurl

leftcurl

Messages
4,085
Name
Leigh
Edit My Images
Yes
this should be any easy one for you boys!

i get a price list from a supplier in excel, so i want to create a formula in the end column to calculate my selling price based on the cost.

So for instance the cost of an item is £79.. but i get -50%, -20%, -10% discount (don't ask me why :bonk:), so it's not a straight forward 80% discount this would give a net cost of £28.44.

so basically i need a formula to calculate the net cost. I can then create another column to calculate my selling price based on the net cost.

hope this is straight forward enough :thumbs:
 
Where are you told the discounts? Are they different for each product? Do you mean you get a 50% discount, then a 20% discount on the 50% discounted price, then a 10% discount on that discounted price?
 
It's just a straightforward 36% discount then?
 
arad85 said:
Where are you told the discounts? Are they different for each product? Do you mean you get a 50% discount, then a 20% discount on the 50% discounted price, then a 10% discount on that discounted price?
Click to expand...

that's exactly right. And it's the same discount for every product.

So the £79 -50% (39.50), -20% (31.60), -10% = Net price of £28.44
 
Leigh,

Then click on the cell and drag it downwards. Excel will create the equivalent formula in each cell as you go downwards.
 
The formula is (assuming original price in A1, 1st disc. in A2, second in A3, third in A4 and assuming A2..A4 are entered as .5, .2 and .1):

=(A1 * (1-A2) * (1-A3) * (1-A4))

just in case you have different discount amounts....
 
You must log in or register to reply here.
Back
Top