The IF function accepts 3 bits of information. It will appear numerous times throughout this article. Logical 1 is the first condition or the logical value to evaluate.
This cheat sheet covers 100s of functions that are critical to know as an Excel analyst.
Returns the starting position of a text string in another text string case sensitive. Converts a text into lower case. For example cell A3 below contains a formula which adds the value of cell A2 to the value of cell A1. It will appear numerous times throughout this article.