Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create Discout Table
Hi, i'm trying to create a discount table in a workbook with 4 sheets products, customers, discount, invoice. My problem is i'm not very experienced and i'm not shore of how to write the formula. The discount % i need Vlookup to calculate on the invoice refers to the amount of qty purchased ie: 0<6= 0% disc, 5<11= 2% disc, there are five in total to calculate. I have tried the If statement but when i use Vlookup to return the value on the invoice it only shows 10% for all quantities. Can someone pls show me how i would write the formula. Many thanks in advance -- 1image ------------------------------------------------------------------------ 1image's Profile: http://www.excelforum.com/member.php...o&userid=28203 View this thread: http://www.excelforum.com/showthread...hreadid=477455 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Create new excel table with filtered records from another table | Excel Worksheet Functions | |||
create pivot table from excel table | Excel Worksheet Functions | |||
How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel | |||
create a source table from a special pasted value dynamic crossed table | Excel Programming |