IF, AND, OR - Logical Functions in Excel
#Excel #exceltipsandtricks #ifandorinexcel
In this video, logical functions is handled comprehensively.
You will learn 3 functions here
1. IF Function :
IF function is one of the most powerful logical function in excel. IF function can handle one test, but within IF function, you can nest in lots of IF function.
If function can handle lesser than, greater than, equal to , not equal to logical test.
2. AND Function :
Next to IF Function, AND function is the second important logical function. To use AND function, at least two condition must be met among the other conditions.
3. OR function:
In OR function, you may have any number of condition but in the specified condition when one of the argument is true, the condition is met.
It all depends on the context in which you want to use the function .