Logical Function in MS Excel: Master AND-OR-IF-NESTED IF Tricks!

Описание: Logical Function in MS Excel | AND-OR-IF-NESTED IF Function | Lesson- 05
#theboldvisionclub
This video Provides Computer Education for all Programming Fundamentals Tutorials and basic concepts including Logical Functions in MS Excel | AND-OR-IF-NESTED IF Function.

The Bold Vision Club Tutorial shows you “ How to use Excel Logical Functions – IF AND OR Nested IF in Urdu. A Logical function of Excel is to make your task so easy whenever you work in Excel with the condition.

All Excel users should know the 3 most powerful Logical Functions: IF, AND, OR. Logical functions allow you to test your data against various conditions and return text or values that will be useful for you.

So, You do not believe how effective these If, And, OR formulae are in themselves. Let’s start with how to use and or function in Excel 2010 2013 2016. Sometimes we use Excel and OR function in one argument. Please watch and read the Excel if and or function tutorial step by step.

(1) IF Function: The Microsoft Excel IF function returns one value if the condition is TRUE, or another value if the condition is FALSE. How to use IF function in excel Syntax of IF Function: IF( condition, [value_if_true], [value_if_false] )

(2) Nested If Function: The Microsoft Excel IF function returns one value if the condition is TRUE, or another value if the condition is FALSE. How to use the NESTED IF function in Excel. If Nested Formula is When we use more than 1 IF we call as Nested If.

(3) OR Function: the Microsoft Excel OR function returns TRUE if any of the conditions are TRUE. Otherwise, it returns FALSE. How to use AND function in excel Syntax of IF Function: OR( condition1, [condition2, ... condition_n] ).

(4) And Function: The Microsoft Excel AND function returns TRUE if all conditions are TRUE. It returns FALSE if any of the conditions are FALSE. How to use OR function in Excel Syntax of IF Function: AND( condition1, [condition2], ... ).


"Don't Forget to SUBSCRIBE, Like, Comment and Share this Video"

Links:
==================================
Lesson- 05:    • Logical Function in MS Excel: Master AND-O...