Hello,

I read countless topics about similar issues but I still can't get it to work.

If I have a value 150x150x6x12000 S355 in B39. I want to return the value 562 in another cell, if B39 ends with 255. If not, then it's 610, UNLESS the cell contains x6x (as opposed to let's say x5x). If it ends in 355 AND contains x6x then it should return 615.

How could I do that?

I am convinced this should work: =IF(ISNUMBER(SEARCH(235; B67)); 562; (IF(ISNUMBER(SEARCH(X6X;B67)); 615; 610)))

But it never returns 615. Only 255 or 610.

Any thoughts on what I'm doing wrong? Am I using the nested IF wrong?

Thanks