After lookup and reference function Logical Functions are the second most often used functions. Based on some logic we can do calculations by using these category functions.
IF condition is the often used logical function. We need to set the criteria’s to be tested before doing the calculation. Logical functions will give two results either TRUE or FALSE. So we can give two sets of calculations as well. If the logical test is TRUE we can supply one set of calculation and if the logical test is FALSE we can supply another set of calculation.
Along with IF you will also learn formulas like OR, TRUE, FALSE, IFERROR, XOR, NOT functions with live examples.