Hi,
In my previous post, I asked the question poorly.
Here is the edit...:
I need to exclude any "SKU" from tab "SKU" that are "Pants" as referred to in column B on "SKU", from the calculation in C31.
Apologies.
Thank you!
Hi,
In my previous post, I asked the question poorly.
Here is the edit...:
I need to exclude any "SKU" from tab "SKU" that are "Pants" as referred to in column B on "SKU", from the calculation in C31.
Apologies.
Thank you!
Last edited by bryden2008; 06-05-2017 at 06:10 AM.
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.
Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
Please change the title of your question to a more appropriate one.
This is one of the forumrules.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Done.
Thank you!
In C33 cell of Input tab Sheet
=IFERROR(VLOOKUP(A33,SKU!A:E,5,0),0)
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
You lookup the rate in B33 and use that in C33 formula: so what is the issue?
Thank you John!
I want the "pants" to not include the $5.00 in cell C31....=IF(B31=0,0,((B31+$D$29)*$C$29)/156)
When VLOOKUP finds the rate as you noted, if it is a "pant" then the fomula should be =IF(B31=0,0,((B31)*$C$29)/156)
Try
=IF($B33=0,0,(($B33+IF(VLOOKUP($A33,SKU!$A$1:$B$1620,2,0)="Pants",0,$D$31))*$C$31)/156)
Ok, that formula excludes the shirts though.
I am trying this -
If A31 is found on SKU tab and is not a pant, then return (the cost in column 5+5.00)*2/156,
If A31 is found on SKU tab and is a pant, then return (the cost in column 5)*2/156
Note- I changed the attachment....
You changed the data from the file I used : now row 31 not 33 so $C$29/$D$29 not $C$31/$D$31: these cells are ABSOLUTE references.
=IF($B31=0,0,(($B31+IF(VLOOKUP($A31,SKU!$A$1:$B$1620,2,0)="Pants",0,$D$29))*$C$29)/156)
My original formula
=IF($B33=0,0,(($B33+IF(VLOOKUP($A33,SKU!$A$1:$B$1620,2,0)="Pants",0,$D$31))*$C$31)/156)
Last edited by JohnTopley; 06-05-2017 at 11:48 AM.
Your formula works, thank you!
Yes you are right. I apologize. I figured that out after.
Apologies and thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks