I am working with excel (office 2003) mainly based on "text-cells". I have
created a formula where I can nestl up to 7 funktions but not more! Goal is
to sort out of a certain text, in a cell, a certain word that has to be shown
at the end.
eg:
=IF(ISNUMBER(FIND("CHANGE",J11)),"CHANGE
ORDER",(IF(ISNUMBER(FIND("NOTICE",J11)),"NOTICE",( IF(ISNUMBER(FIND("NCR",J11)),"NCR",(IF(ISNUMBER(FI ND("Plus/Minus",J11)),"PLUS/MINUS",(IF(ISNUMBER(FIND("Minutes",J11)),"MOM",(IF (ISNUMBER(FIND("RFI",J11)),"RFI")))))))))))&IF(B11 ="","","")