Logical functions are some of the most popular and useful in Excel. They can test values in other cells and perform actions dependent upon the result of the test. This helps us to automate tasks in our spreadsheets.
The IF function is the main logical function in Excel and is, therefore, the one to understand first. It will appear numerous times throughout this article.