Hi there,
I have this workshop Manufacturing spreadsheet here and I have this problem where "Column C" says a certain "Number" (ie: 165, 180, 205 and 250) and in "Column E" gives me the number that I need to cut a length of Steel I need but what I really want is to have "Column E" "-103" when "Column C" says only "205" I would really appreciate any Help I can get on this. Please help. Thank you.
Last edited by Eric_Raine_85; 03-09-2017 at 12:50 AM. Reason: Title Change
Try
E3Formula:
Please Login or Register to view this content.
Drag down!!
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Unfortunately that didn't work. Thankyou.
Please explain what would be expected result.Originally Posted by Eric_Raine_85
However try
=IF(ISBLANK(A3),0,IF(C3=250,A3-103,A3-73))
On a side note use this in C2, instead of those IF's...
=IF(A3="","",CHOOSE(MATCH(A3,{0,1000,1400,1850,2400,3100,3650}),150,165,180,205,230,250))
Not really sre I understand what you want here, but may be this?
E3=IF(A3="",0,IF(C3=250,-103,A3-73))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
YESS, Thankyou shukla.ankur281190 That second one worked thank-you so much, I;ve been stuck on that for a while now Thankyou again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks