Hàm ISBLANK – Hàm kiểm tra xem ô là giá trị trống trong Excel

Nguồn bài viết: Hàm ISBLANK – Hàm kiểm tra xem ô là giá trị trống trong Excel

The following article introduces you to the function ISBLANK – One of the functions in the group of very popular information functions in Excel.

ISBLANK function - Function to check if a cell is a blank value in Excel

Describe: The function checks if the cell is an empty value or not. The function returns the value True if is an empty value and otherwise False.

Syntax: ISBLANK(value)

In there:

value: The value you want to determine if an empty value is a required parameter.

Attention:

– The function returns the value True if is empty and returns False if not empty value.

For example:

Check the values ​​in value is it an empty value?

Check if the values ​​in value are empty or not?

– In the cell to be calculated, enter the formula: =ISBLANK(C6)

In the cell to be calculated enter the formula =ISBLANK(C6)

– Press Enter -> return value is:

Pressing Enter returns the value

– Similarly copy the formula for the remaining values ​​to get the result:

Copy the formula for the remaining values ​​to get the result

Above are instructions and some specific examples when using the function ISBLANK in Excel.

Good luck!

Những bài viết liên quan : Thủ Thuật Excel

Nguồn : Thủ Thuật Phần mềm

Mọi sự sao chép, trích dẫn vui lòng ghi rõ nguồn: congthucexcel.com



from congthucexcel.com https://ift.tt/NXlDS42
via Congthucexcel.com

Nhận xét