How to use the ‘EMPTY’ function in Excel

In this note we will talk about, what does the Excel function EPUSTO (ISBLANK) mean and how it can be used in work.

Excel has a separate category of functions, which are called ‘E’, so, ‘If’. It means a condition, in which the contents of the cell correspond or do not correspond to the truth.

How it works

So, to find out, is a particular table cell occupied or empty, in Excel there is a function ‘EMPTY’.

The syntax of this function is quite simple:

  • after ‘=’ and ‘EMPTY’, specify that cell in parentheses, which you want to check,
  • press enter, to confirm the execution of the command. Now the function will return the value ‘False’, if the cell contains any data, or ‘Truth’, if the cell is empty.

If you want to replace the values ‘True’ and ‘False’ in your document, It’s not a problem. You can combine ‘EMPTY’ with the ‘IF’ function - this will allow you to set your own values.

Syntax of the ‘IF’ function, as you know, it consists of three parts: ‘Boolean expression’, ‘Value if true’ and ‘Value if false’.
Boolean expression =IF (E) is EMPTY (C3). C3 is the string being checked. 0 corresponds to ‘Value if True’, and 1 corresponds to the ‘Value of if’.

If cell C3 is empty, the function outputs the value 0, otherwise 1.
After the semicolon, you can enter in the ‘Value if True’ that value, which the program should output, if the cell is empty. In ‘Value_if_load_’, enter the value, which should appear, if the corresponding cell is filled.

Watch carefully that, so that all brackets are placed correctly. Otherwise, Excel will not be able to perform this function.

Press Enter, to view the result.