Here are the types of IS functions you can choose from, and you can see some examples below: ISBLANK: Tests whether a is blank. ISOMITTED: Tests whether the value in a LAMBDA function is missing.

Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.