If formular (2 ifs) works alone, but not together
I have a problem with an if formular. Individually it works for me, but not together. Can You help me?
=WENN(ISTZAHL(SUCHEN("PK";GLÄTTEN($E5)));LINKS((TE XTNACH(GLÄTTEN($E5);"PK";1));4)*1;WENN(ISTZAHL(SUC HEN("KR";GLÄTTEN($E5)));LINKS((TEXTNACH(GLÄTTEN($E 5);"KR";1));4)*1))
individually:
=WENN(ISTZAHL(SUCHEN("PK";GLÄTTEN($E5)));LINKS((TE XTNACH(GLÄTTEN($E5);"PK";1));4)*1)
=WENN(ISTZAHL(SUCHEN("KR";GLÄTTEN($E5)));LINKS((TE XTNACH(GLÄTTEN($E5);"KR";1));4)*1)
Next Problem is, I would like to have the 4-string Number or 3-string Number behind the "PK" or "PKR"
Is it possible?
|