The IF statement is a common logical function in Excel. The SWITCH statement is less well known, but you can use it instead of the IF statement in some situations.

This article will explain how to use the conditional functions IF, AND, OR and NOT on Microsoft Excel. Each of these functions can be used as part of a formula in a cell to compare data samples in any ...

Simon Hurst explains how through logical functions such as IF (), AND (), OR (), NOT () and IFERROR () you can automate Excel functions, and explores alternatives to the use of IF (). There are many ...

Excel's logical functions test whether a statement or data is true or false, before enabling the program to carry out an action based on the result. They are useful for analyzing data, automating ...