Forum Discussion

nic140274's avatar
nic140274
Copper Contributor
Feb 21, 2020
Solved

Automatic Selling price calculator

Hello, could someone help me with a formula to calculate the selling price of an item given some specific guidelines?   Basically I sell products on a website which I buy from a supplier, The web...
excel
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Feb 22, 2020

    nic140274 Not sure I follow. If you refer to the 25% in cell K4, that is not a revenue. I just entered the tax% there that you charge to the customer. PErhaps I should have removed your column header. Then I don't have to type "25%" in every formula where it is used. Just a habit.

     

    The tax that you pay on you purchases are not costs and the tax that you charge to your customers is not revenue. I doubt that the 1 euro and the 15% are inclusive of taxes, but if you are certain that this is really the case, enter:

    =1/1.21

     in C4, and

    =15%/1.21

    in D5. 

    Have attached the schedule with these formulae.

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Feb 22, 2020
Mijn fout. Weet niet waarom ik 25% gebruikte. Prettig weekend.
nic140274's avatar
nic140274
Copper Contributor
Feb 23, 2020

Riny_van_Eekelen 

OK I spent all day on this yesterday, I did lots of tests and matched them to manual calculations and looks really good, I am very happy and I consider this now resolved.

Sorry while I live here in the Netherlands my Dutch is still really bad 🙂

 

Bedankt voor al je harde werk om me te helpen

 

Regards

Nic from Huizen

Resources