ISBLANK function - The function checks if a cell is a blank value in Excel
The following article introduces you to ISBLANK function - one of the functions in the information function group is very popular in Excel.
ISBLANK function - The function checks if a cell is a blank value in Excel Picture 1
Description: The function checks whether the cell is a blank value or not. The function returns True if it is blank and vice versa is False.
Syntax: ISBLANK (value)
Inside:
- value: The value you want to determine is a blank value or not, is a required parameter.
Attention:
- The function returns True value if it is blank and returns False if it is not blank.
For example:
Check if the value in the value is blank?
ISBLANK function - The function checks if a cell is a blank value in Excel Picture 2
- In the cell to calculate, enter the formula : = ISBLANK (C6)
ISBLANK function - The function checks if a cell is a blank value in Excel Picture 3
- Press Enter -> return value is:
ISBLANK function - The function checks if a cell is a blank value in Excel Picture 4
- Similarly copying the formula for the remaining values results:
ISBLANK function - The function checks if a cell is a blank value in Excel Picture 5
Above are instructions and some specific examples when using ISBLANK function in Excel.
Good luck!
You should read it
- Add a checkbox to the Excel spreadsheet
- How to use the IFS function in Excel 2016
- How to use COUNTIF function on Excel
- How to use the IF function in Excel
- DCOUNTA function, how to use the function to count non-empty cells in Excel
- How to use the Match function in Excel
- How to use ADDRESS function in Excel
- Basic Excel functions that anyone must know
- How to use the SUM function to calculate totals in Excel
- INDIRECT function in Excel - How to use INDIRECT function and examples using INDIRECT function
- CELL function to look up information of a cell in Excel
- How to use Hlookup function on Excel
May be interested
ISERR function - Function returns True if the value is any error except # N / A error in Excel
ISERROR function - The function returns True if the value is any error in Excel
ISEVEN function - Function returns True value if the value is even in Excel
ISFORMULA function - The function returns True if that cell refers to a cell containing a formula in Excel
ISLOGICAL function - The function returns True if the value is a logical value in Excel
ISNA function - The function returns True if the value is an # N / A error value in Excel