Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


Hi :)
I think so but most people might not understand you.  It would be nice to see 
mis-posts like this occasionally :)
Regards from
Tom :)



________________________________
From: luiz <lcoluiggi@gmail.com>
To: users@libreoffice.org
Sent: Wed, 11 May, 2011 15:28:26
Subject: Re: [libreoffice-users] Calc, InString einer Zelle prüfen

Why in german language?

Can i post in brazilian portuguese too ;)

Luiz
Ich muss eine Bankleitzahlen-Tabelle prüfen, die folgenden Aufbau hat.
*Bankleitzahl*     *Bankname manuell
*     *Ergebnis*
100 200 00     Berliner Bank    
150 400 68     Commerzbank Neubrandenburg    
200 700 00     Deutsche Bank Hamburg    
214 500 00     Spk Mittelholstein Rendsbg    
250 500 00     NORD LB HANNOVER    


Ich suche eine Formel, die in der Spalte "Ergebnis" z.B. anzeigt:
wenn Stelle 4 der Bankleitzahl = 4, dann Ergebnis = Commerzbank
wenn Stelle 4 der Bankleitzahl = 7, dann Ergebnis = Deutsche Bank
wenn Stelle 4 der Bankleitzahl = 5, dann Ergebnis = Sparkasse
etc.



-- 
Unsubscribe instructions: E-mail to users+help@libreoffice.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted
-- 
Unsubscribe instructions: E-mail to users+help@libreoffice.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.