Hi Everyone,
This is my first Chandoo.org post so please be understanding if my jargon and spelling aren't perfect.
I've recently been working on a Invoice in Excel 2010 and I need to have an option of a discount for customers with codes.
I've set up a drop-down menu in Cell G3 with the options: A (10% discount) B (5% discount) and N/A (no discount). In a separate cell(F13) I'd like it to enter the discount amount i.e. 10% or 0.9 which I can then multiply against the subtotal to get the final cost.
This is my first Chandoo.org post so please be understanding if my jargon and spelling aren't perfect.
I've recently been working on a Invoice in Excel 2010 and I need to have an option of a discount for customers with codes.
I've set up a drop-down menu in Cell G3 with the options: A (10% discount) B (5% discount) and N/A (no discount). In a separate cell(F13) I'd like it to enter the discount amount i.e. 10% or 0.9 which I can then multiply against the subtotal to get the final cost.