Die WENN Funktion erklärt mit Beispielen | Excel Grundlagen Tutorial
Digitale Profis
@digitaleprofisAbout
Hey, wir sind Johannes Ruof und Timothy Meixner! Wir sind studierte (und leidenschaftliche ;)) Informatiker und haben in der Vergangenheit mit Unternehmen wie Udemy, Google Deutschland und LinkedIn zusammengearbeitet. Auf unserem Kanal gibt es alles zu Künstlicher Intelligenz. Egal, ob ChatGPT, Microsoft Copilot oder Google Gemini. Außerdem gibt es wöchentlich ein KI-News-Update und hilfreiche Tutorials zu beliebten KI-Tools. Es ist für alle etwas dabei und alle sind willkommen. Wenn Du Vorschläge für uns hast, zu welchen Themen wir Videos produzieren sollen, dann schreib uns einfach in den Kommentaren! Wir freuen uns darauf, mit Euch in die spannende Welt der Künstlichen Intelligenz einzutauchen. Liebe Grüße Johannes & Timothy Impressum - Angaben gemäß § 5 TMG: Meixner & Ruof UG (haftungsbeschränkt) Dahlienweg 19 73760 Ostfildern Vertreten durch: Johannes Ruof Timothy Meixner Umsatzsteuer-ID: Umsatzsteuer-Identifikationsnummer gemäß §27a Umsatzsteuergesetz: DE321128110
Video Description
Mit der WENN Funktion in Excel können wir den Inhalt von Zellen dynamisch bestimmen. Dabei machen wir das, was in der Zelle stehen soll abhängig von einem sogenannten Wahrheitstest, der entweder WAHR oder FALSCH zurückgibt. Das kann zum Beispiel etwas sein wie „Steht in der Zelle A1 das Wort aktiv“. Die WENN Funktion wird in Excel enorm häufig verwendet. In diesem Video erkläre ich Dir deshalb ganz in Ruhe, von Beginn an, mit praktischen Beispielen, wie die Funktion aufgebaut ist und was wir mit ihr machen können. Beispieldatei und weitere Beispieldateien für andere Funktionen hier: https://meindigitalesmarketingde-my.sharepoint.com/:f:/g/personal/johannes_ruof_digitaleprofis_de/Ev8fg4qDeCNCsYVSKgh9uewB7TytGw7-q0GfknQgYQ4sig?e=6gSIvn Link zum Office-Kurs: https://bit.ly/3DLpVDh Videovorschläge, Feedback und Kritik kannst Du uns jederzeit in den Kommentaren mitteilen!
![PivotTable Grundlagen in Microsoft Excel für Anfänger:innen [PivotTable-Tutorial 1/5]](https://imgz.pc97.com/?width=500&fit=cover&image=https://i.ytimg.com/vi/x16no3YM4Cg/hqdefault.jpg)
Upgrade Your Everyday
AI-recommended products based on this video
Amazon Echo Show 8 (newest model), With Spatial Audio, Smart Home Hub, and Alexa, Charcoal
Apple AirPods 4 Wireless Earbuds, Bluetooth Headphones, with Active Noise Cancellation, Adaptive Audio, Transparency Mode, Personalized Spatial Audio, USB-C Charging Case, Wireless Charging, H2 Chip
Wireless Earbuds, Bluetooth 5.4 Headphones, True Wireless Stereo Earphones with IPX7 Waterproof, Noise Cancelling Mic, Fast Charging and Comfort Fit Ear Buds for Sports/Workouts - Black
Apple AirPods 4 Wireless Earbuds, Bluetooth Headphones, Personalized Spatial Audio, Sweat and Water Resistant, USB-C Charging Case, H2 Chip, Up to 30 Hours of Battery Life, Effortless Setup for iPhone
Apple AirPods Pro 2 Wireless Earbuds, Active Noise Cancellation, Hearing Aid Feature, Bluetooth Headphones, Transparency, Personalized Spatial Audio, High-Fidelity Sound, H2 Chip, USB-C Charging
Smart Watch for Men/Women, 1.95" AMOLED Fitness Tracker Watches with Bluetooth Calls/Flashlight/100+ Sport Modes Heart Rate/Sleep Monitor Ultra Lightweight Ultrathin Design
Smart Watch for Men Women (Answer/Make Call), 1.96" HD Smartwatch Fitness Activity Tracker, 110+ Sports IP68 Waterproof, Heart Rate/Sleep Monitor/Pedometer/Calories, Fitness Watch for Android iOS
![Apple Watch Series 10 [GPS 46mm case] Smartwatch with Rose Gold Aluminium Case with Light Blush Sport Band - M/L. Fitness Tracker, ECG App, Always-On Retina Display, Water Resistant](https://m.media-amazon.com/images/I/61nNNMI1cFL._AC_UL960_FMwebp_QL65_.jpg)
Apple Watch Series 10 [GPS 46mm case] Smartwatch with Rose Gold Aluminium Case with Light Blush Sport Band - M/L. Fitness Tracker, ECG App, Always-On Retina Display, Water Resistant
![Apple Watch Series 10 [GPS 42mm case] Smartwatch with Jet Black Aluminium Case with Black Sport Band - S/M. Fitness Tracker, ECG App, Always-On Retina Display, Water Resistant](https://m.media-amazon.com/images/I/6105jZyXyPL._AC_UL960_FMwebp_QL65_.jpg)
Apple Watch Series 10 [GPS 42mm case] Smartwatch with Jet Black Aluminium Case with Black Sport Band - S/M. Fitness Tracker, ECG App, Always-On Retina Display, Water Resistant
NOCO Boost GB40: 1000A UltraSafe Jump Starter – 12V Lithium Battery Booster Pack, Portable Jump Box, Power Bank & Jumper Cables - for 6.0L Gas and 3.0L Diesel Engines
UGREEN Nexode Power Bank 20000mAh 130W Portable Charger 72Wh PD Fast Charging 3-Port USB C Battery Pack with TFT Smart Display for MacBook/iPad/iPhone 16/Samsung S24 and More
ANKER 737 Power Bank, 24,000mAh 3-Port Laptop Portable Charger with 140W Fast Charging, Smart Display, for Outdoor Work, Compatible with iPhone 16/15/14 Series, Vision Pro, Samsung, MacBook, and More
VOLTME Portable Charger, Slim 10000mAh 5V/3A Power Bank, USB C in&Out High-Speed Charging Battery Pack, Travel Essentials Dual Output Compatible with iPhone 16 15 14 13 12 Samsung Google iPad etc
Apple AirPods 4 Wireless Earbuds, Bluetooth Headphones, with Active Noise Cancellation, Adaptive Audio, Transparency Mode, Personalized Spatial Audio, USB-C Charging Case, Wireless Charging, H2 Chip
Apple AirPods 4 Wireless Earbuds, Bluetooth Headphones, Personalized Spatial Audio, Sweat and Water Resistant, USB-C Charging Case, H2 Chip, Up to 30 Hours of Battery Life, Effortless Setup for iPhone
Apple AirPods Pro 2 Wireless Earbuds, Active Noise Cancellation, Hearing Aid Feature, Bluetooth Headphones, Transparency, Personalized Spatial Audio, High-Fidelity Sound, H2 Chip, USB-C Charging
Bose QuietComfort Bluetooth Headphones, Wireless Headphones with Active Over Ear Noise Cancelling and Mic, Deep Bass, Up to 24 Hours of Playtime, White Smoke
Barnyard Designs Indoor Herb Garden Planter Set with Tray, Metal Windowsill Plant Pots with Drainage for Outdoor or Indoor Plants, Set/3 (Black)
Eye Contact Web Camera for Desktop Computer – 1080P USB Camera with Microphone & Stand, Center Cam for Laptop or Desktop, Manual Focus, Plug & Play for macOS & Windows（Black）
![PEHAEL 3+3Pack for iPhone 17 Pro Max Privacy Screen Protector with Camera Lens Protector Full Coverage Anti-Spy Tempered Glass Film 9H Hardness Easy Installation Bubble Free [6.9 inch]](https://m.media-amazon.com/images/I/61PnVkv6KKL._AC_UL960_FMwebp_QL65_.jpg)
PEHAEL 3+3Pack for iPhone 17 Pro Max Privacy Screen Protector with Camera Lens Protector Full Coverage Anti-Spy Tempered Glass Film 9H Hardness Easy Installation Bubble Free [6.9 inch]
![Ailun 3 Pack Screen Protector for iPhone 16 Pro Max [6.9 inch] + 3 Pack Camera Lens Protector with Installation Frame,Sensor Protection,Dynamic Island Compatible,Case Friendly Tempered Glass Film](https://m.media-amazon.com/images/I/815keamN-BL._AC_UL960_FMwebp_QL65_.jpg)
Ailun 3 Pack Screen Protector for iPhone 16 Pro Max [6.9 inch] + 3 Pack Camera Lens Protector with Installation Frame,Sensor Protection,Dynamic Island Compatible,Case Friendly Tempered Glass Film
