When evaluating just two conditions the XOR function returns. If your logical test contains the AND function Microsoft Excel returns TRUE if all the conditions are. To use multiple IF function where we can add multiple logical tests after the first logical condition and TRUE value again insert another IF Function followed by the different logical values to be compared with TRUE value result.
Use the IF function in combination with the AND function and the OR function and become an Excel expert.
The OR and AND functions usually reduce the formula size. In this article we shall see a good number of examples where we have paired VLOOKUP with IF condition in Excel. The OR and AND functions usually reduce the formula size. The number of IF functions required in multiple IF statements is the number of criteria minus 1.