Exel Formel

%3CLINGO-SUB%20id%3D%22lingo-sub-2996511%22%20slang%3D%22de-DE%22%3EExel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2996511%22%20slang%3D%22de-DE%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3EI%20use%3A%20Windows%2010%20and%20Exel%202010.%20I%20am%20writing%20a%20billing%20program%20for%20myself.%20The%20following%20formula%20works.%20Display%20%22%20False%20%22%20.%3C%2FP%3E%3CP%3EQuestion%20what%20am%20I%20doing%20wrong%3F%3F%20Thanks%20for%20the%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20formula%3A%20%3DIF(G35-G33%26gt%3B0%2C%22%20Your%20ancillary%20costs%20advance%20payments%20for%202022%20remain%20unchanged%20%22%3B%22%20Please%20note%3A%20Your%20new%20prepayment%20for%20NBK%20from%2001.01.2022%20%3A%22%3D'Master%20data%20Hs%2011'!G32)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2996511%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2996570%22%20slang%3D%22en-US%22%3ERe%3A%20Exel%20Formel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2996570%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1227233%22%20target%3D%22_blank%22%3E%40pepe6%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPerhaps%20this%20way%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DWENN((G35-G33%26gt%3B0)%3B%22Ihre%20Nebenkosten%20Vorauszahlungen%20f%C3%BCr%202022%20bleiben%20unver%C3%A4ndert%20%22%3B%22Bitte%20beachten%20Sie%3A%20Ihre%20neue%20Vorauszahlung%20f%C3%BCr%20NBK%20ab%20dem%2001.01.2022%20%3A%22%20%26amp%3B%20'Stammdaten%20Hs%2011'!G32)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2997144%22%20slang%3D%22de-DE%22%3ERe%3A%20Exel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2997144%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20info%20was%20very%20helpful.%20Basically%20it%20worked%20but%20it%20comes%20only%20the%20number%20200%20-%20and%20not%20like%20the%20reference%20number%20200%2C00%20%E2%82%AC.How%20can%20I%20solve%20this%3F%26nbsp%3B%3C%2FP%3E%3CP%3E(this%20is%20the%20result%2C%20)%26nbsp%3B%20%22%3C%2FP%3E%3CP%3E%3CSPAN%3E%22%20Please%20note%20......................%2001.01.2022%3A%20200%20%3CBR%20%2F%3E%20Thank%20you.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2997267%22%20slang%3D%22en-US%22%3ERe%3A%20Exel%20Formel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2997267%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1227233%22%20target%3D%22_blank%22%3E%40pepe6%3C%2FA%3E%26nbsp%3BChange%20this%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%26amp%3B%20'Stammdaten%20Hs%2011'!G32%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eto%20this%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%26amp%3B%20TEXT('Stammdaten%20Hs%2011'!G32%2C%20%22%23%230%20%E2%82%AC%22)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B...assuming%20that%20my%20translator%20used%20the%20correct%20German%20for%20the%20English%20TEXT%20function.%20The%20part%20in%20the%20end%20between%20the%20quotation%20marks%20is%20how%20you%20want%20the%20amount%20to%20be%20formatted.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEdit%3A%20I%20guess%20in%20German%20the%20%2C%20should%20be%20a%20%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2997406%22%20slang%3D%22de-DE%22%3ERe%3A%20Exel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2997406%22%20slang%3D%22de-DE%22%3ESorry%20but%20it%20doesn't%20work.%20Don't%20know%20why!!%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2997625%22%20slang%3D%22de-DE%22%3ERe%3A%20Exel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2997625%22%20slang%3D%22de-DE%22%3EI'll%20try%20again%20tomorrow%20%22%20Thank%20you%20.%20At%20the%20moment%20I%20am%20again%20the%20solution%20where%20only%20the%20number%20200%20appears.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hallo,

ich benütze:  Windows 10 und Exel 2010. Ich schreibe für mich ein Abrechnungsprogramm. Folgende Formel funktioniert .  Anzeige  " Falsch " .

Frage was mach ich verkehrt ??   Danke für die Hilfe.

 

Meine Formel: =WENN(G35-G33>0;"Ihre Nebenkosten Vorauszahlungen für 2022 bleiben unverändert ";"Bitte beachten Sie: Ihre neue Vorauszahlung für NBK ab dem 01.01.2022 :"='Stammdaten Hs 11'!G32)

7 Replies

@pepe6 

Perhaps this way:

=WENN((G35-G33>0);"Ihre Nebenkosten Vorauszahlungen für 2022 bleiben unverändert ";"Bitte beachten Sie: Ihre neue Vorauszahlung für NBK ab dem 01.01.2022 :" & 'Stammdaten Hs 11'!G32)

 

@Riny_van_Eekelen 

 

Danke für die Info war sehr hilfreich. Grundsätzlich hat es funktioniert aber es kommt nur die Zahl 200 - und nicht wie die Bezugszahl  200,00 €.  Wie kann ich das lösen. 

(so sieht das Ergebnis aus, )  "  

" Bitte beachten ...................... 01.01.2022:   200
Danke. 

@pepe6 Change this:

 

& 'Stammdaten Hs 11'!G32

 

to this:

 

& TEXT('Stammdaten Hs 11'!G32, "##0 €")

 

 ...assuming that my translator used the correct German for the English TEXT function. The part in the end between the quotation marks is how you want the amount to be formatted.

 

Edit: I guess in German the , should be a ;

Sorry aber es funktioniert nicht . Weiß nicht warum !!
Ich probiere es morgen noch mal " Danke . Momentan bin ich wieder der Lösung wo nur die Zahl 200 erscheint.

@pepe6 Look at the attached file and focus on the TEXT part in the formula. You should see it in German.

Danke für die Hilfe. Es passt !!