TeachToEach shows you “ How to use Excel Logical Functions - IF AND OR Nested IF in Hindi. A Logical function of excel is make your task so easy whenever is you work in excel with the condition.
How to use excel logical function in excel is always a difficult task to users. So , This video solve your problem in a minute. Whatever you do either is it a simple sheet or making dashboard, this will help you a lot.
You do not believe how effective these If, And, OR formulae in itself. Let’s start how to use and or function in excel 2010 2013 2007.
Sometimes we use excel And OR function in one argument.
Please watch and read 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 NESTED IF function in excel.
If Nested Formula is When we use more than 1 IF we called as Nested If.
(3) OR Fucntion : he 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], ... )
Please subscribe my channel “TeachToeach” for more videos of excel tutorial in hindi.
For More Videos:
1) Reverse Lookup Formula Vlookup with Choose Function in Excel - • Reverse Lookup Formula...
2) How to use Vlookup formula in Excel 2013 Hindi - • Vlookup Formula in exc...
3) 2D-Two Dimensional Lookup Formula Vlookup with Match in Excel - • 2D-Two Dimensional Loo...
4) How to Lock individual Cell in worksheet of excel - • How to Lock individual...
5) How to consolidate multiple worksheets into Pivot Table in Excel Hindi - • How to consolidate mul...
Негізгі бет Excel Logical Functions IF AND OR NESTED IF in Hindi By TeachToeach
Пікірлер: 402