Logical functions are essential for the arsenal of any Excel user. They are the building blocks of many automated reports and Excel models.
They automate decision-making and perform specific actions based on the value of a cell or handle errors that may be expected.
The chapter begins with multiple examples of the quite brilliant IF function. This function is a gateway function for users going from a basic to intermediate level. But you will never stop using this effective little function.
We then proceed into more complex logical formula ...