Hi Everyone,
One of my clients asked for some help and I'm stuck. I'm betting the Index (or Hlookup nested with IF) formula will be needed to solve it but have no clue, so here goes. Pardon if I'm a little long winded.
If you look at the attached file, focus on row 10 since it will give you the "gist" of things. Here is the deal. If you open the file you will see a bunch of percentage discounts for various products, looking at row 10 here is what I'd like to figure out. I'm looking to create a formula that will return the value from just the row and multiply it by the proposed inventory cell value. (See file for notes)
For example the current inventory and proposed inventory are just manually entered as needed. The fun starts when you type in the discount you want to offer. Say you want to offer a 50% discount, the value in the corresponding cell is (p10) is 115. Once the discount is selected multiply the discount amount by p10. Granted that sounds quite confusing so if you open the sheet and look in columns U, V, W, X and Y, I've spelled things out a bit so the end goal is more clearly explained.
Thanks again for all your help and look forward to seeing what y'all come up with.
-Dave
One of my clients asked for some help and I'm stuck. I'm betting the Index (or Hlookup nested with IF) formula will be needed to solve it but have no clue, so here goes. Pardon if I'm a little long winded.
If you look at the attached file, focus on row 10 since it will give you the "gist" of things. Here is the deal. If you open the file you will see a bunch of percentage discounts for various products, looking at row 10 here is what I'd like to figure out. I'm looking to create a formula that will return the value from just the row and multiply it by the proposed inventory cell value. (See file for notes)
For example the current inventory and proposed inventory are just manually entered as needed. The fun starts when you type in the discount you want to offer. Say you want to offer a 50% discount, the value in the corresponding cell is (p10) is 115. Once the discount is selected multiply the discount amount by p10. Granted that sounds quite confusing so if you open the sheet and look in columns U, V, W, X and Y, I've spelled things out a bit so the end goal is more clearly explained.
Thanks again for all your help and look forward to seeing what y'all come up with.
-Dave
