GOOGLE FOGLI tutorial 20: Funzioni logiche (SE, IFS, E, O, XOR)

☕ Support me with a free donation ➜ https://www.paypal.me/FrancescaMartorana 📗 Request the material created specifically for this course, writing to me through the contact form on my website ➜ https://www.FantasticaMenteING.com​ 🌍 ⭐ Google Sheets #googlesheets - Video course in Italian 📊 Tutorial 20: Logical functions in Google Sheets IF (IF), IFS, AND (AND), OR (OR), XOR ⭐ In this video tutorial, we will explore Logical Functions in Google Sheets, a fundamental tool for taking your spreadsheets to an advanced level. Logical functions allow you to analyze data and make decisions based on specific conditions. 🔍 Here's what you'll learn: 🟢 IF Function: How to test a condition and return a value if it is true or another value if it is false. ▶ Syntax: =IF(condition; value_if_true; value_if_false) 🟢 IFS Function: How to handle multiple conditions without nesting multiple IFs inside each other. ▶ Syntax: =IFS(condition1; value1; condition2; value2; ...) 🟢 AND Function: How to check if all the specified conditions are true. ▶ Syntax: =AND(condition1; condition2; ...) 🟢 OR Function: How to check if at least one of the specified conditions is true. ▶ Syntax: =OR(condition1; condition2; ...) 🟢 XOR Function: How to check if only one of the specified conditions is true. ▶ Syntax: =XOR(condition1; condition2; ...) ● Practical example: We simulated a real scenario in which we evaluate the results of students based on specific criteria: • Pass or fail (using the IF function with AND). • Detailed evaluation (using the IFS function together with the AVERAGE function). • Verification of partial passing (using the OR function). • Verification of an exclusive condition (using the XOR function). This tutorial will guide you step by step through clear explanations, precise syntax and examples applicable in real life. Useful links: ⮕ Syntax and arithmetic formulas in Google Sheets:    • GOOGLE FOGLI tutorial 2: Sintassi e formul...   ⮕ SUM, AVERAGE, MAX, MIN functions in Google Sheets:    • GOOGLE FOGLI tutorial 18: funzioni SOMMA, ...   ⮕ Syntax and counting formulas in Google Sheets:    • GOOGLE FOGLI tutorial 19: CONTA.VALORI, CO...   ⮕ Simple and nested logical functions (IF AND OR) in Excel    • EXCEL tutorial 7A: Funzioni logiche ( SE E...   👍 Follow me on Facebook ➜   / fantasticamenteing   💙 Follow me on Instagram ➜   / fantasticamenteing   ♪ Follow me on TikTok ➜   / fantasticamenteing   📱Subscribe to the WhatsApp channel ➜ https://whatsapp.com/channel/0029VaKN... 🔔 To be updated on the next uploads, subscribe to the channel and activate notifications by clicking on the bell. Thanks for following me! 💼 Eng. Francesca Martorana #google #sheets #function