Hi Dolores

Seems to me that =IF(J11="","",IF(J11="CHANGE","CHANGE
ORDER",IF(J11="Plus/Minus","PLUS/MINUS",IF(J11="Minutes","MOM",J11)))) will
do the trick equally well. However, if you really need to go further, you
can get past the 7nested IF issue in a number of ways

"Dolores" wrote:

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 ="","","")