Excel Einheitsmatrix Formel "MEINHEIT"

%3CLINGO-SUB%20id%3D%22lingo-sub-1416099%22%20slang%3D%22de-DE%22%3EExcel%20Unit%20Matrix%20Formula%20%22MEINHEIT%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1416099%22%20slang%3D%22de-DE%22%3E%3CP%3EHello%20together%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20very%20much%20hope%20someone%20can%20help%20me.%20I%20have%20the%20latest%20Excel%20version%20but%20for%20some%20reason%20the%20formula%20%22MEINHEIT%22%20for%20a%20unit%20matrix%20does%20not%20work%20for%20me.%20Excel%20always%20tells%20me%20that%20the%20formula%20does%20not%20exist%20and%20after%20I%20have%20entered%20the%20formula%20appears%20in%20all%20selected%20cells%20%22NAME%22%20I%20also%20do%20not%20find%20the%20formula%20in%20the%20formulas%20at%20the%20top%20of%20the%20bar%20(where%20the%20formulas%20from%20different%20areas%20are%20listed%20such%20as%20financial%20mathematics%2C%20statistics%2C%20etc.)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20question%20now%20is%2C%20do%20I%20have%20to%20stop%20this%20formula%20irgdendo%20or%20do%20I%20have%20to%20set%20it%20up%20somewhere%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20very%20pleased%20to%20receive%20a%20quick%20response.%20Thank%20you%20in%20advance!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDear%20greetings%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1416099%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1416998%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Einheitsmatrix%20Formel%20%22MEINHEIT%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1416998%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F678932%22%20target%3D%22_blank%22%3E%40Nella1312%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3EMaybe%20this%20could%20help%20you.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fde-de%2Farticle%2Fmeinheit-funktion-c9fe916a-dc26-4105-997d-ba22799853a3%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fde-de%2Farticle%2Fmeinheit-funktion-c9fe916a-dc26-4105-997d-ba22799853a3%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1418681%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Einheitsmatrix%20Formel%20%22MEINHEIT%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1418681%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F678932%22%20target%3D%22_blank%22%3E%40Nella1312%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20attached%20contains%20some%20matrix%20functions%20prepared%20using%20an%20English%20localisation%20of%20Office%20365.%26nbsp%3B%20Do%20the%20functions%20translate%2C%20show%2C%20and%20work%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hallo zusammen,

 

ich hoffe sehr jemand kann mir weiterhelfen. Ich habe die neueste Excel Version jedoch klappt aus irgendeinem Grund bei mir die Formel "MEINHEIT" für eine Einheitsmatrix nicht. Excel sagt mir stets, die Formel existiere nicht und nachdem ich die Formel eingegeben habe erscheint steht in allen markierten Zellen "NAME" Ich finde die Formel jedoch auch nicht bei den Formeln oben in der Leiste (wo die Formeln aus dn unterschiedlichsten Bereichen aufgelistet sind wie Finanzmathematik, Statistik etc.)

 

Meine Frage ist nun, muss ich diese Formel irgdendo einstellen oder muss diese irgendwo eingerichtet werden?

 

Über eine schnelle Rückmeldung würde ich mich sehr freuen. Vielen Dank schon einmal vorab!

 

Liebe Grüße

2 Replies
Highlighted
Highlighted

@Nella1312 

The attached contains some matrix functions prepared using an English localisation of Office 365.  Do the functions translate, show, and work?