check if text doesn't exist

[BORUCH]

HI all

I need an excel formula
If a cell containseither the word "LB." or "LBS." but it doesn't contain, with itin the same cell the word “OZ" or "oz", then it should be blank.

Thanks

 

[igold]

Two things.

1) You are missing a condition, what should the cell be if it does not match your criteria as stated?

2) you do realize that a cell can contain either a formula or a value but not both.

igold

 

[BORUCH]

Two things.

1) You are missing a condition, what should the cell be if it does not match your criteria as stated?

2) you do realize that a cell can contain either a formula or a value but not both.

igold

=IF(ISNUMBER(SEARCH("LBS",G112)),"",IF(ISNUMBER(SEARCH("LB",G112)),"",IF(AND(OR(ISNUMBER(SEARCH("LBS",G112)),(ISNUMBER(SEARCH("LB",G112)))),ISNUMBER(SEARCH("OZ",G112))),LEFT(G112,LOOKUP(2^15,SEARCH({"X","-"},G112))-1),F112)))

Above is my formula the problem is it is not working,
What i'm trying to accomplish is if the cell contains only the word "lbs" or ONLY the word "lb" then it should be blank if it contains the word lbs or the word lb AND IN THE SAME CELL IT ALSO HAS THE word "oz" OR "OZ" then ,LEFT(G112,LOOKUP(2^15,SEARCH({"X","-"},G112))-1

 

[igold]

The cell cannot both contain a formula and be blank if a condition is met. It is a circular reference.

 

[Aladin Akyurek]

HI all

I need an excel formula
If a cell containseither the word "LB." or "LBS." but it doesn't contain, with itin the same cell the word “OZ" or "oz", then it should be blank.

Thanks

Care to post some examples (input) along with the desired results, i.e. desired output?