- Популярные видео
- Авто
- Видео-блоги
- ДТП, аварии
- Для маленьких
- Еда, напитки
- Животные
- Закон и право
- Знаменитости
- Игры
- Искусство
- Комедии
- Красота, мода
- Кулинария, рецепты
- Люди
- Мото
- Музыка
- Мультфильмы
- Наука, технологии
- Новости
- Образование
- Политика
- Праздники
- Приколы
- Природа
- Происшествия
- Путешествия
- Развлечения
- Ржач
- Семья
- Сериалы
- Спорт
- Стиль жизни
- ТВ передачи
- Танцы
- Технологии
- Товары
- Ужасы
- Фильмы
- Шоу-бизнес
- Юмор
Excel Logical Functions - IF, AND, OR | Complete Tutorial in Urdu / Hindi | Microsoft Excel
#ExcelLogicalFunctions #ExcelIF #ExcelAND #ExcelOR #MicrosoftExcel #ExcelTutorial #ExcelForBeginners #LearnExcel #IFANDORinExcel #ExcelFormulas #ExcelTipsAndTricks
Hello everyone!
In this video, we are going to learn the most important and powerful Logical Functions in Microsoft Excel – IF, AND, and OR – in a simple and complete way. These functions are the foundation of decision-making formulas in Excel and are widely used in daily office work, student records, business calculations, and more.
👇 What you will learn in this video:
🔹 IF Function:
Learn the structure and usage of the IF function to check a single condition and return results based on TRUE or FALSE.
Example: If a student’s marks are more than 40, show “Pass”, otherwise “Fail”.
Syntax: =IF(logical_test, value_if_true, value_if_false)
🔹 AND Function:
Use the AND function to check multiple conditions. It returns TRUE only if all conditions are TRUE.
Example: If marks are greater than 40 and attendance is above 75%, then “Eligible”.
Syntax: =AND(condition1, condition2, ...)
🔹 OR Function:
The OR function checks multiple conditions and returns TRUE if any one of them is TRUE.
Example: If either marks or attendance meet the criteria, then “Considered”.
Syntax: =OR(condition1, condition2, ...)
Who should watch this video?
This tutorial is perfect for students, teachers, office workers, data entry operators, or anyone learning Excel. Whether you’re a beginner or intermediate learner, this video will help you understand logic-based functions easily.
🧠 Did you know?
With Logical Functions, you can create automatic grading systems, eligibility checkers, salary rule applications, and much more in Excel!
🔔 If you find this video helpful, don’t forget to LIKE, SHARE & SUBSCRIBE to the channel! @KHANITHUB
📢 Let me know in the comments which function you found most useful, or suggest any topic you'd like to learn next!
Видео Excel Logical Functions - IF, AND, OR | Complete Tutorial in Urdu / Hindi | Microsoft Excel канала KHAN IT HUB
Hello everyone!
In this video, we are going to learn the most important and powerful Logical Functions in Microsoft Excel – IF, AND, and OR – in a simple and complete way. These functions are the foundation of decision-making formulas in Excel and are widely used in daily office work, student records, business calculations, and more.
👇 What you will learn in this video:
🔹 IF Function:
Learn the structure and usage of the IF function to check a single condition and return results based on TRUE or FALSE.
Example: If a student’s marks are more than 40, show “Pass”, otherwise “Fail”.
Syntax: =IF(logical_test, value_if_true, value_if_false)
🔹 AND Function:
Use the AND function to check multiple conditions. It returns TRUE only if all conditions are TRUE.
Example: If marks are greater than 40 and attendance is above 75%, then “Eligible”.
Syntax: =AND(condition1, condition2, ...)
🔹 OR Function:
The OR function checks multiple conditions and returns TRUE if any one of them is TRUE.
Example: If either marks or attendance meet the criteria, then “Considered”.
Syntax: =OR(condition1, condition2, ...)
Who should watch this video?
This tutorial is perfect for students, teachers, office workers, data entry operators, or anyone learning Excel. Whether you’re a beginner or intermediate learner, this video will help you understand logic-based functions easily.
🧠 Did you know?
With Logical Functions, you can create automatic grading systems, eligibility checkers, salary rule applications, and much more in Excel!
🔔 If you find this video helpful, don’t forget to LIKE, SHARE & SUBSCRIBE to the channel! @KHANITHUB
📢 Let me know in the comments which function you found most useful, or suggest any topic you'd like to learn next!
Видео Excel Logical Functions - IF, AND, OR | Complete Tutorial in Urdu / Hindi | Microsoft Excel канала KHAN IT HUB
KHAN IT HUB excel excel if function excel functions excel tutorial microsoft excel excel formulas and functions ms excel excel formulas function logical function in excel if function and function logical functions in excel excel tips learn excel excel for beginners if function excel excel 365 excel function excel and function excel formulas and functions tutorial or function in excel if function in excel and function in excel excel 2016
Комментарии отсутствуют
Информация о видео
20 апреля 2025 г. 14:28:40
00:18:32
Другие видео канала





















