Cómo usar la Función SI(), Y() y O() en Excel | Explicación Fácil + Ejercicios
In this video, you'll learn to master three of the most important and frequently used functions in Excel: IF(), AND(), and OR(). I'll explain step-by-step how they work, when to use each one, and how to combine them to create more powerful and useful formulas for your work or studies. It includes real-world examples, practical cases, and exercises you can solve to reinforce what you've learned. Ideal for students, teachers, accountants, administrators, and anyone who wants to improve their Excel skills. Watch the course online: 🌐https://eltiotech.com/curso-de-excel/ Watch the course in the Playlist: • Nuevo Curso de Excel 2026 (Básico, Interme... (00:00) Introduction to the IF, AND, and OR functions in Excel (00:26) Downloading the file (01:13) General explanation of logical functions and the practice file (01:43) How the AND function works (02:36) Building the AND function step by step (04:08) Applying IF + AND in the first exercise (Discount) (05:16) Second exercise: three conditions with AND (06:14) Testing by modifying values to obtain TRUE (06:39) Integrating IF for custom text (50% scholarship) (07:01) Validating the Exercise with Multiple Combinations (07:59) Introduction to the OR function: true if a condition is met (08:32) Practical exercise with OR (08:52) Using IF + OR to display default values (09:15) Second exercise with OR and multiple conditions (09:33) Integrating IF for the final result (“Pass”) (09:56) More complex exercise: combining AND and OR (10:18) Applying multiple criteria with combined OR and AND (10:42) Conceptual explanation: conjunction (AND) and disjunction (OR) (11:02) Analyzing the statement and logic of the combined exercise (11:29) Identifying the conditions of AND and OR (11:58) Hierarchical order of logical evaluation (12:25) Constructing the AND part (average + attendance) (12:56) Constructing the condition of the O (13:20) Final integration of Y and O into a single formula VISIT OUR WEBSITES: 🔵 https://www.eltiotech.com 🔵 https://www.tiotech.net 📩 Join us on Telegram: https://t.me/eltiotech 📒 Join us on WhatsApp: https://whatsapp.com/channel/0029VaEa... FOLLOW US ON OUR SOCIAL MEDIA 🔴 TikTok: / eltiotech_ 🔴 Instagram: / luismiguelvelavela 🔴 / eltiotechoficial

How to Use the IF Function with Multiple Conditions to Calculate Discount Percentage in Excel

20 Ejercicios con la Función SI en Excel | Para Descargar y Practicar 📊

STOP Doing Excel Calculations Manually! Learn SUMIF in 60 Seconds - Bonus - COUNTIF

Average Function, AverageIf, AverageIfSet (Downloadable Exercises)

Power BI sin complicaciones 🚀 Curso GRATIS para empezar YA

EXCEL Secrets They Ask You for in Any JOB INTERVIEW

Los 5 símbolos más poderosos de Excel (casi nadie los conoce)

🏆 Domina la función SI como un Analista de datos en Excel

FEW people use them 😱 | DATABASE FUNCTIONS in Excel

⭐️ ¿Cómo usar TABLAS DINAMICAS en EXCEL? 👏 De la forma más SIMPLE QUE EXISTE 👌

HOMILÍA DE HOY | CADA SITUACIÓN DIFÍCIL DIOS LA TRANSFORMA EN OPORTUNIDAD | PADRE FREDDY BUSTAMANTE

What is Excel? - Learn the basics

Función SI, Y y O en Excel | Ejemplos Prácticos y Casos Reales

What Life in China is REALLY Like for Single Women (Utopia or Exhausting Grind?)

Pop Art Screensaver - Art Screensaver for your TV

The Max, Min, MaxIfSet, and MinIfSet Functions in Excel (Downloadable Exercises)

How to Use Excel's XLOOKUP Function (Goodbye VLOOKUP and HLOOKUP)

5 Excel Functions to MASTER a Job Interview

START MONDAY WITH FAITH | LORD STRENGTHEN MY HEART FOR WHAT IS TO COME | FATHER FREDDY BUSTAMANTE

