Excel: If Not Empty - How to Use the IF Function

With the right formulas and functions, you can automate many tasks and processes in Excel. Using the IF function, you have the ability to have Excel perform actions when the selected cell is empty, for example.

This is how you apply the IF function

If you want Excel to add something or perform some other action when a cell is empty, for example, you can specify this using the IF function.

• The syntax of the IF function looks like this: "=WENN(check;[then_value];[else_value])"
• For example, if you want something to be added automatically if the selection is a cell with content, the formula could look like this: "IF(B1="";"";B1+20)".
• Alternatively, you can also customize the formula to perform a subtraction instead of an addition, or to output text.

Check cells with ISTLEER function

With the ISTLEER function, Excel automatically checks a cell selection you specify for its contents.

• The syntax of the ISTLEER function is simple. To use the function, simply enter "=ISTLEER(cell)" in a free field.
• If no cell contents are present, Excel will output the result "TRUE" by default.
• If Excel finds a value during the check, "FALSE" will be returned as the result.

If you would like to extend the functions of the ISTLEER function, you can combine it with a IF function, for example. By nesting the two functions, you are then able, for example, to get a digit as output results instead of TRUE or FALSE.

You might also be interested in:

How to enable macros in ExcelExcel on iPad - how to get to the app Print