Formula is:
=BY$6&BY8&IF(H8<=25,25,(IF(H8<=38.1,150,300)))
Result is BEND2300 should be BEND2150
Cell H8 = 34 but this is a result of the formula =MID(L8,1,(FIND("X",L8)-1))
consequently, it does not recognize 34 as a number
(even if I format column H to number)
so it defaults to 300
if I add a column =H8 formatted as a number, and use that cell in the IF statement, it works, I'd rather not add another column,
is there a way to modify the formula to make the result of =MID(L8,1,(FIND("X",L8)-1)) be understood as a number?
BTW, L8 is 34X4 (I'm extracting the diameter from the ODxWall entry)
Since the OD is 34 it goes on machine 150
Bookmarks