Register
Log In
Unanswered
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
Dashboards
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
Dashboards
June 25, 2016
Offline
Just use =VLOOKUP(E10,$E$38:$J$65,6,FALSE)*-N10
Answers Post
Most Users Ever Online: 57
Currently Online: Mark Lund, Rudi, Max Neumann
17 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Ajay Mukhi
Stephen Motte
Rodney Hoyle
michael pitre
Samantha Burleson
Krishnaa Kurugod
David McSwain
Shameem Nassiree
Alanna Henderson
Janel Oz
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
