formula help please

[tomtom]

Hope some out there can lend me a hand. Having problems with C1 can be a % or can also be an amount. Every entry can vary
here goes.
A1 contains buy in price €
B1 contains discount €, it varies but is always a figure in €
C1 Contains another discount in € OR it may contain a % discount based on the buy in price.
D1 is to contain the sellout price based on A1,B1,C1.

The % discount varies with product.
Any help out there with a formula for D1

[swatsp0p]

I need more information on your calculation method for the two discounts. You don't tell us how to apply the second discount. Is this amount deducted from the base price BEFORE applying the 1st discount or after? Is this 2nd discount applied to the 1st discount? (e.g. disc. 1=10%, discount 2=50% of #1 for a total of 15% discount), etc, etc.

More info, please.

[tomtom]

We take the buy in price A1 and we subtract B1. This gives us a figure.Then we work on ie. 3% of buyin price or a discouint amount of € and we subract this from total A1-B1. giving us D1 sellout price.

any clearer ? hope it is

[swatsp0p]

I will make a big assumption that the Cash value in C1 will never be less than E1.00 (sorry, USA, I don't have the Euro sign readily available). With that said, try this formula in D1:

=IF(C1<1,(A1-(A1*B1))-((A1-(A1*B1))*C1),(A1-(A1*B1))-C1)

It would be way easier if you added a couple of columns to "subtotal" these calculations, but this should work for you.

Good Luck

Bruce