Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a Price Book
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a Price Book
Create a table with your net values in one column and your markup
amount in the second column. The use the VLOOKUP function. E.g, =VLOOKUP(A1,$B$1:$B$20,2,TRUE) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "silverstang_23" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |