Product price with marges

**Kayserili** · 09-20-2007, 04:17 AM

Hey guys,

i am researching to get a code so i can calculate my sale price.. I have tryd some codes with H/V-Lookup but it doesn't resolve my problem..

I have a pricelist with more than 5000 products. Its very very very hard to calculate my saleprice 1 by 1 :D

Aaaand They are not sorted.. (thats the biggest problem!)

So what i want is:

That a code that i can copy to ALL sale price cells THAT can say
Hey this is a motherboard so he will get 50% fork and the sale price = 132
Hey this is a CPU so he will get 40% fork and the saleprice = 63,23

I have added an attachment as an example excel sheet.

Its very important for me.. I know the basics and a little bit of programming excel but not so far that i can set a code like this..

**Dean England** · 09-20-2007, 08:54 AM

I think I know what you want. Take a look at this example and see if one of these formulae will work for you.

Dean

**Kayserili** · 09-20-2007, 04:41 PM

Hey!! This is a quite good formula!!! I have tried it on a few things.. I will try it out on my pricelist tomorrow.. I meaned not Discount but i mean:

i get the product for 100 by supplier and i add 3% and my saleprice = 103

:D

But i just change the "discount" amount and it works too..

I will try it and you will hear from me of this is what i need

Thank you very very very much and sorry for my not-so-good- English

**Dean England** · 09-20-2007, 04:55 PM

I hope it works for you. Let me know if it does or doesn't.

Dean

**Kayserili** · 09-21-2007, 03:18 AM

Originally Posted by Dean England

I hope it works for you. Let me know if it does or doesn't.

Dean

Dear Dean,

thank you very very much!!! Its perfect!

I can work with it.. The only thing is that i have to say 103% in case of 3%.. But doesn't matter.. It wil take too much time of you to do that too

Thank you very much!! You solved a problem that a %&$#@ teacher of EXCEL couldn't solve and he thinks he is a prof in excel...

If you need Software contact me with a PM and i will try to help you 2