Excel függvény probléma szerveren

Ez a téma lezárásra került a moderátor által. A lezárás oka: Semmi köze programozáshoz/fejlesztéshez, így keresnivalója sincs itt → PCForum.hu-ra való.
Excel függvény probléma szerveren
2022-06-22T12:07:02+02:00
2022-06-22T12:07:02+02:00
2022-08-12T09:35:32+02:00
3csoki1szazas
Sziasztok!

Van egy borzalmasan hosszú IF/AND/OR függvényem ami, ha laptopon használom az excelt működik, minden esetben van találat, ha pedig szerveren (ugyan azt a táblázatot), akkor a sorok nagy részében #value! az eredmény.  Ugyan az az office csomag van mind a két erőforráson.

Csatolmányban egy példa a két táblázat ugyan azon sorairól.

Ez pedig a függvény:

=IF(AND(AX2="Intermediaries",AY2="Tour Operator",AZ2="Tour Operator",BB2="Mid Market",BC2="Corporate"),"Mid Market",IF(AND(AX2="Intermediaries",AY2="Broker",AZ2="Mid Market",ISNA(BA2)),"Broker",IF(AND(AX2="Insurance/Leasing Co",AZ2=""),"",IF(AND(IFNA(IF(AND(AZ2<>"Top Road Assistance",AZ2<>"Other Leasing",BC2="Insurance/Leasing Co",BA2="Insurance/Leasing Co"),"Top Leasing",IF(AND(BC2="Insurance/Leasing Co",OR(,AY2="Top Leasing",AZ2="Top Leasing",BB2="Top Leasing")),"Top Leasing",IF(AND(AY2="Travel Agent",ISNA(BA2)),"Travel Agent",IF(AND(AY2="Strategic",AZ2="Strategic",ISNA(BA2),BB2<>"Mid Market"),"Strategic",IF(AND(OR(AY2="",AY2="Partnership"),AZ2="Partnership",ISNA(BA2)),"Partnership",IF(AND(AY2="Partnership",ISNA(BA2)),"Partnership",IF(AND(AX2="Corporate",AY2="Mid Market",AZ2="Direct",BB2=0),"Direct",IF(AND(AY2="Broker",OR(AZ2="Telesales",AZ2="Strategic",AZ2="Mid Market")),AZ2,IF(AY2="Broker","Broker",IF(AY2="Tour Operator","Tour Operator",IF(AND(IFNA(BA2,"NA"),AZ2="Intermediaries",OR(AY2="Hotel",AY2="")),"Hotel",IF(AND(BC2="Corporate",ISNA(IF(BC2="direct","Direct",IF(BC2="INSURANCE/LEASING CO",AZ2,IF(ISNA(BB2),AZ2,BB2))))),"Mid Market",+IF(BC2="direct","Direct",IF(BC2="INSURANCE/LEASING CO",AZ2,IF(ISNA(BB2),AZ2,BB2))))))))))))))),IF(AND(BC2="Insurance/Leasing Co",OR(,AY2="Top Leasing",AZ2="Top Leasing",BB2="Top Leasing",AX2="Insurance/Leasing Co"),AZ2<>"Other Leasing",AZ2<>"Top Road Assistance"),"Top Leasing",IF(AND(AY2="Travel Agent",ISNA(BA2)),"Travel Agent",IF(AND(AY2="Strategic",AZ2="Strategic",ISNA(BA2),BB2<>"Mid Market"),"Strategic",IF(AND(OR(AY2="",AY2="Partnership"),AZ2="Partnership",ISNA(BA2)),"Partnership",IF(AND(AY2="Partnership",ISNA(BA2)),"Partnership",IF(AND(AX2="Corporate",AY2="Mid Market",AZ2="Direct",BB2=0),"Direct",IF(AND(AY2="Broker",OR(AZ2="Telesales",AZ2="Strategic",AZ2="Mid Market")),AZ2,IF(AY2="Broker","Broker",IF(AY2="Tour Operator","Tour Operator",IF(AND(IFNA(BA2,"NA"),AZ2="Intermediaries",OR(AY2="Hotel",AY2="")),"Hotel",IF(AND(BC2="Corporate",ISNA(IF(BC2="direct","Direct",IF(BC2="INSURANCE/LEASING CO",AZ2,IF(ISNA(BB2),AZ2,BB2))))),"Mid Market",+IF(BC2="direct","Direct",IF(BC2="INSURANCE/LEASING CO",AZ2,IF(ISNA(BB2),AZ2,BB2)))))))))))))))=0,BC2="Corporate"),"Mid Market",IFNA(IF(AND(AZ2<>"Top Road Assistance",AZ2<>"Other Leasing",BC2="Insurance/Leasing Co",BA2="Insurance/Leasing Co"),"Top Leasing",IF(AND(BC2="Insurance/Leasing Co",OR(,AY2="Top Leasing",AZ2="Top Leasing",BB2="Top Leasing")),"Top Leasing",IF(AND(AY2="Travel Agent",ISNA(BA2)),"Travel Agent",IF(AND(AY2="Strategic",AZ2="Strategic",ISNA(BA2),BB2<>"Mid Market"),"Strategic",IF(AND(OR(AY2="",AY2="Partnership"),AZ2="Partnership",ISNA(BA2)),"Partnership",IF(AND(AY2="Partnership",ISNA(BA2)),"Partnership",IF(AND(AX2="Corporate",AY2="Mid Market",AZ2="Direct",BB2=0),"Direct",IF(AND(AY2="Broker",OR(AZ2="Telesales",AZ2="Strategic",AZ2="Mid Market")),AZ2,IF(AY2="Broker","Broker",IF(AY2="Tour Operator","Tour Operator",IF(AND(IFNA(BA2,"NA"),AZ2="Intermediaries",OR(AY2="Hotel",AY2="")),"Hotel",IF(AND(BC2="Corporate",ISNA(IF(BC2="direct","Direct",IF(BC2="INSURANCE/LEASING CO",AZ2,IF(ISNA(BB2),AZ2,BB2))))),"Mid Market",+IF(BC2="direct","Direct",IF(BC2="INSURANCE/LEASING CO",AZ2,IF(ISNA(BB2),AZ2,BB2))))))))))))))),IF(AND(BC2="Insurance/Leasing Co",OR(,AY2="Top Leasing",AZ2="Top Leasing",BB2="Top Leasing",AX2="Insurance/Leasing Co"),AZ2<>"Other Leasing",AZ2<>"Top Road Assistance"),"Top Leasing",IF(AND(AY2="Travel Agent",ISNA(BA2)),"Travel Agent",IF(AND(AY2="Strategic",AZ2="Strategic",ISNA(BA2),BB2<>"Mid Market"),"Strategic",IF(AND(OR(AY2="",AY2="Partnership"),AZ2="Partnership",ISNA(BA2)),"Partnership",IF(AND(AY2="Partnership",ISNA(BA2)),"Partnership",IF(AND(AX2="Corporate",AY2="Mid Market",AZ2="Direct",BB2=0),"Direct",IF(AND(AY2="Broker",OR(AZ2="Telesales",AZ2="Strategic",AZ2="Mid Market")),AZ2,IF(AY2="Broker","Broker",IF(AY2="Tour Operator","Tour Operator",IF(AND(IFNA(BA2,"NA"),AZ2="Intermediaries",OR(AY2="Hotel",AY2="")),"Hotel",IF(AND(BC2="Corporate",ISNA(IF(BC2="direct","Direct",IF(BC2="INSURANCE/LEASING CO",AZ2,IF(ISNA(BB2),AZ2,BB2))))),"Mid Market",+IF(BC2="direct","Direct",IF(BC2="INSURANCE/LEASING CO",AZ2,IF(ISNA(BB2),AZ2,IF(AND(T2<>"",AY2="",AZ2="",ISNA(BA2),BB2="Mid Market",BC2="Corporate"),"Mid Market","Mid Market"))))))))))))))))))))
Mutasd a teljes hozzászólást!

Ez a téma lezárásra került a moderátor által. A lezárás oka: Semmi köze programozáshoz/fejlesztéshez, így keresnivalója sincs itt → PCForum.hu-ra való.
Tetszett amit olvastál? Szeretnél a jövőben is értesülni a hasonló érdekességekről?
abcd