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.
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?
- In the cell to calculate, enter the formula : = ISBLANK (C6)
- Press Enter -> return value is:
- Similarly copying the formula for the remaining values results:
Above are instructions and some specific examples when using ISBLANK function in Excel.
Good luck!
You should read it
- 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
May be interested
- ISERR function - Function returns True if the value is any error except # N / A error in Exceliserr function: the function returns true if the value is any error except # n / a error syntax: iserr (value)
- ISERROR function - The function returns True if the value is any error in Exceliserror function: the function returns true if the value is any error in excel. syntax: iserror (value)
- ISEVEN function - Function returns True value if the value is even in Exceliseven function: the function returns true if the value is even in excel. syntax: iseven (value)
- ISFORMULA function - The function returns True if that cell refers to a cell containing a formula in Excelisformula function: the function returns true if that cell refers to a cell containing the formula. support functions from excel 2013 onwards. syntax: isformula (reference)
- ISLOGICAL function - The function returns True if the value is a logical value in Excelislogical function: the function returns true if that value is a logical value in excel. syntax: islogical (value)
- ISNA function - The function returns True if the value is an # N / A error value in Excelisna function: the function returns true if the value is an # n / a error value in excel. syntax: isna (value)