Log In
Register
Home
February 11, 2015
Offline
Hello
I'm using a PC – Excel 2013
I need help with a formula.
In column Z, I have a formula that is looking at column E, if the product matches the product listed between row 38- 65, and column J 38-65, states yes, then we need to supply a 5% discount from column N.
I need a 5% discount off of the price for Print charge (column N).
I know there is a better way to complete this. Any advice would be greatly appreciated.
Please see attached example.
Thanks
Amy
See Answer
VIP
Trusted Members
June 25, 2016
Offline
Hi Amy
A VLOOKUP should solve your problem.
Try this : In cell Z10 enter =IF(VLOOKUP(E10,$E$38:$J$65,6,FALSE)="Yes",5%,0)*-N10
A more preferred way is to have the 5% entered into the row 38-65 replacing "Yes" and 0% to replace "No"
Then any changes to the discount structure will only involve changing the lookup table instead of the formulas.
Hope this helps.
February 11, 2015
Offline
Hi SunnyKow
This is great. Thank you. How would I write the formula if I changes the "yes/no" to 5% / 0%?
I would like to make easier for my coworkers to understand.
Thank you so much
Amy
VIP
Trusted Members
June 25, 2016
Offline
Just use =VLOOKUP(E10,$E$38:$J$65,6,FALSE)*-N10
Answers Post
