Formula Editor

%3CLINGO-SUB%20id%3D%22lingo-sub-1574642%22%20slang%3D%22en-US%22%3EFormula%20Editor%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1574642%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Everybody%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ecurrently%2C%20I%20am%20developing%20a%20tool%20for%20a%20client%20for%20company%20controlling%20purposes.%20My%20formulas%20are%20getting%20longer%20and%20longer.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%2C%20I%20have%20spent%20more%20than%20two%20hours%20looking%20for%20a%20comfortable%20formula%20editor%20-%20preferably%20as%20plugin%20-%20where%20formulas%20are%20displayed%20and%20editable%20in%20programmer's%20view.%20I%20did%20not%20find%20anything%20(except%20for%20some%20chinese%20guys%20who%20-%20for%20whatever%20reason%20-%20do%20not%20want%20any%20money%20for%20a%20microsoft%20plugin...).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAm%20I%20_really_%20the%20only%20one%20who%20does%20not%20like%20the%20endless%20lines%20of%20Excel-formulas%20where%20you%20have%20to%20imagine%20all%20the%20interlacing%2C%20indentations%20and%20dependencies%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20suggest%20me%20an%20appropriate%20tool%20for%20that%20purpose.%20It%20does%20not%20have%20to%20be%20free.%20Priceless%20would%20be%20enough%20%3B-).%20And%20it%20should%20work%20with%20the%20German%20version%20of%20Excel%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAm%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1574642%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1574669%22%20slang%3D%22de-DE%22%3ESubject%3A%20Formula%20Editor%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1574669%22%20slang%3D%22de-DE%22%3E%3CBR%20%2F%3EI'm%20not%20sure%20what%20exactly%20is%20required.%20But%20send%20this%20link%20...%20Maybe%20it%20will%20help.%20If%20not%2C%20just%20ignore%20it.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Creating%20custom%20functions%20in%20Excel%20%3CBR%20%2F%3E%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fde-de%2Foffice%2Ferstellen-benutzerdefinierter-funktionen-in-excel-2f06c10b-3622-40d6-a1b2-b6748ae8231f%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fde-de%2Foffice%2Ferstellen-benutzerdefinierter-funktionen-in-excel-2f06c10b-3622-40d6-a1b2-b6748ae8231f%3C%2FA%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Nikolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1574674%22%20slang%3D%22en-US%22%3EBetreff%3A%20Formula%20Editor%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1574674%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%20for%20your%20reply.%20I%20was%20looking%20for%20a%20tool%20that%20would%20make%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DWENNFEHLER(WENN(AF6%3D%22H%22%3B(INDIREKT(%22%5BData.xlsm%5DSuSa_%22%26amp%3B%24C%241%26amp%3B%2212!K%22%26amp%3BAB6)*-1)%3BINDIREKT(%22%5BData.xlsm%5DSuSa_%22%26amp%3B%24C%241%26amp%3B%2212!K%22%26amp%3BAB6))%3B%22%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ereadable%20like%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DWENNFEHLER(%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20WENN(AF6%3D%22H%22%3B(%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BINDIREKT(%22%5BData.xlsm%5DSuSa_%22%26amp%3B%24C%241%26amp%3B%2212!K%22%26amp%3BAB6)*-1)%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BINDIREKT(%22%5BData.xlsm%5DSuSa_%22%26amp%3B%24C%241%26amp%3B%2212!K%22%26amp%3BAB6))%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%3B%22%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMaybe%20that%20explains%20it%20a%20litte%20bit%20better.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1574718%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20Editor%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1574718%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F753337%22%20target%3D%22_blank%22%3E%40OfficeWorks%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerhaps%20I%20know%20what%20did%20you%20mention%20in%20the%20first%20post.%20I%20also%20don't%20know%20proper%20formatter%2C%20if%20you%20find%20something%20please%20share.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1574781%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20Editor%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1574781%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F753337%22%20target%3D%22_blank%22%3E%40OfficeWorks%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3Emaybe%20I%20can%20help%20with%20this%20link.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EIs%20in%20German%20as%20requested%20by%20you.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CH1%20id%3D%22toc-hId-501591287%22%20id%3D%22toc-hId-501591287%22%20id%3D%22toc-hId-501591287%22%20id%3D%22toc-hId-501591287%22%20id%3D%22toc-hId-501591287%22%20id%3D%22toc-hId-501591287%22%20id%3D%22toc-hId-501591287%22%3EFormel-Editor%3C%2FH1%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fde-de%2Foffice%2Fformel-editor-6eac7d71-3c74-437b-80d3-c7dea24fdf3f%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fde-de%2Foffice%2Fformel-editor-6eac7d71-3c74-437b-80d3-c7dea24fdf3f%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20font%20will%20enable%20display%20of%20Math%20equations%20created%20using%20Microsoft%20Equation%20Editor%203.0.%3C%2FP%3E%3CP%3EInstall%20MTEXTRA.TTF%20(%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3Eis%20not%20supported%20in%20the%20download%2C%20unfortunately%20I%20cannot%20send%20it%20to%20you%2C%20please%20download%20it%20yourself)%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ETo%20install%20this%20font%20on%20a%20single%20PC%3A%3CBR%20%2F%3E1.%20Locate%20the%20MTEXTRA.TTF%20font%20file%20you%20just%20downloaded.%3CBR%20%2F%3E2.%20Right-click%20the%20font%20file%20and%20choose%20%3CSTRONG%3EInstall%3C%2FSTRONG%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAfter%20that%20visit%20this%20Link%3C%2FP%3E%3CP%3E%3CA%20href%3D%22http%3A%2F%2Fwww.wiris.com%2Fen%2Fequation_editor%2Fmicrosoft%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.wiris.com%2Fen%2Fequation_editor%2Fmicrosoft%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3ERead%20the%20instructions%20carefully%20in%20the%20first%20link%20from%20Microsoft%2C%20all%20details%20are%20described%20there.%3C%2FSPAN%3E%20%3CSPAN%3EHope%20it%20was%20this%20kind%20of%20editor.%3C%2FSPAN%3E%20%3CSPAN%3EIf%20not%2C%20just%20ignore%20it.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EPS.%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3EThe%20editor%20is%20only%20available%20in%20English%2C%20but%20that%20doesn't%20mean%20that%20it%20doesn't%20work%20with%20German%20office%20versions%2C%20so%20read%20it%20carefully.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EI%20wish%20you%20a%20pleasant%20day.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%221%202%203%204%205%206%207%22%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20Community%20members%20reading%20here.%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%221%202%203%204%205%206%207%22%3E*%20Beware%20of%20scammers%20posting%20fake%20support%20numbers%20here.%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1574818%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20Editor%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1574818%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20equation%20editor%2C%20not%20formatter%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1574831%22%20slang%3D%22de-DE%22%3ERe%3A%20Formula%20Editor%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1574831%22%20slang%3D%22de-DE%22%3EToday%20is%20not%20my%20day%2C%20talk%20out%20of%20turn%20...%20I%20have%20to%20pull%20myself%20together%20...%20Thanks%20for%20the%20hint%20again.%20%3CBR%20%2F%3E%20Gotta%20put%20my%20thoughts%20together%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20thx%20%3CBR%20%2F%3E%20Nikolino%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1734226%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20Editor%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1734226%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F753337%22%20target%3D%22_blank%22%3E%40OfficeWorks%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdeveloper.microsoft.com%2Fen-us%2Fexcel%2Fblogs%2Fformula-editor-hack-productivity%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdeveloper.microsoft.com%2Fen-us%2Fexcel%2Fblogs%2Fformula-editor-hack-productivity%2F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1734749%22%20slang%3D%22de-DE%22%3ERe%3A%20Formula%20Editor%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1734749%22%20slang%3D%22de-DE%22%3ETried%20to%20download%20the%20editor%2C%20but%20without%20success.%20It%20appears%2C%20Error%20404%20Not%20found.%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi Everybody,

 

currently, I am developing a tool for a client for company controlling purposes. My formulas are getting longer and longer.

 

Now, I have spent more than two hours looking for a comfortable formula editor - preferably as plugin - where formulas are displayed and editable in programmer's view. I did not find anything (except for some chinese guys who - for whatever reason - do not want any money for a microsoft plugin...).

 

Am I _really_ the only one who does not like the endless lines of Excel-formulas where you have to imagine all the interlacing, indentations and dependencies?

 

Can anyone suggest me an appropriate tool for that purpose. It does not have to be free. Priceless would be enough ;-). And it should work with the German version of Excel

 

Thank you for your time.

 

Am 

8 Replies
Highlighted

I'm not sure what exactly is required. but send this link ... maybe it will help. If not, just ignore it.

Erstellen benutzerdefinierter Funktionen in Excel
https://support.microsoft.com/de-de/office/erstellen-benutzerdefinierter-funktionen-in-excel-2f06c10...


Nikolino
I know I don't know anything (Socrates)
Highlighted

@Nikolino 

Hi,

 

thanks for your reply. I was looking for a tool that would make

 

=WENNFEHLER(WENN(AF6="H";(INDIREKT("[Data.xlsm]SuSa_"&$C$1&"12!K"&AB6)*-1);INDIREKT("[Data.xlsm]SuSa_"&$C$1&"12!K"&AB6));"")

 

readable like

 

=WENNFEHLER(

        WENN(AF6="H";(

                   INDIREKT("[Data.xlsm]SuSa_"&$C$1&"12!K"&AB6)*-1);

                   INDIREKT("[Data.xlsm]SuSa_"&$C$1&"12!K"&AB6))

         ;"")

 

Maybe that explains it a litte bit better.

Highlighted

@OfficeWorks 

Perhaps I know what did you mention in the first post. I also don't know proper formatter, if you find something please share.

Highlighted

@OfficeWorks 

 

maybe I can help with this link.

Is in German as requested by you.

 

Formel-Editor

https://support.microsoft.com/de-de/office/formel-editor-6eac7d71-3c74-437b-80d3-c7dea24fdf3f

 

This font will enable display of Math equations created using Microsoft Equation Editor 3.0.

Install MTEXTRA.TTF (is not supported in the download, unfortunately I cannot send it to you, please download it yourself)

To install this font on a single PC:
1. Locate the MTEXTRA.TTF font file you just downloaded.
2. Right-click the font file and choose Install.

 

After that visit this Link

http://www.wiris.com/en/equation_editor/microsoft

 

Read the instructions carefully in the first link from Microsoft, all details are described there. Hope it was this kind of editor. If not, just ignore it.

PS. The editor is only available in English, but that doesn't mean that it doesn't work with German office versions, so read it carefully.

I wish you a pleasant day.

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

* Beware of scammers posting fake support numbers here.

 

Highlighted

@Nikolino 

That's equation editor, not formatter

Highlighted
Today is not my day, talk out of turn ... I have to pull myself together ... Thanks for the hint again.
Gotta put my thoughts together

thx
Nikolino
Highlighted
Tried to download the editor, but without success. It appears, Error 404 Not found.