Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a business store and instead of using markup of percentage, I say "if
my net is between $0-$59, i add $30. If it's between $60-$99, i add $36 to my net...etc." how can i create a formula to put that into Excel so i don't have to keep on doing every product by hand? Also, If a customer buys more than one product, i would give them package pricing, and i would look up my net, and if it's between $0-$59, i add $30 then subtract $3.55, etc. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
looking for a price book template | Excel Discussion (Misc queries) | |||
I am looking for a template for a professional looking price book | Excel Discussion (Misc queries) | |||
how to set up quotes that pull from price book | Excel Discussion (Misc queries) | |||
Need help creating an Excel formla to calculate price before sales tax | Excel Discussion (Misc queries) | |||
Creating a price list,with different row heights | Excel Discussion (Misc queries) |