1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Excel’s ISBLANK function is one of a group of “Information Functions” that can be used to find out information about a specific cell.

The ISBLANK function's job is to check to see if a certain cell is empty or not. If the cell is empty, a value of TRUE is returned by the function. If the cell contains data of any kind - such as a text label, a number, or a date - a FALSE value is returned.

Since Excel does not distinguish between an empty cell and one containing a zero, errors can sometimes occur if a blank cell is mistakenly included in a formula. The ISBLANK function can be used to avoid introducing such errors into a spreadsheet.

To find out all the details of using this function read the short article on the Excel 2007 ISBLANK Function.

Related Articles

March 4, 2009 at 4:54 pm
(1) Michael Jarquin says:

I need help, I have a spreadsheet that has a column of names with acres in another column. However, the first column has duplicates of the names. Each duplicate has acres in the next column. I would like to add up the acres for each duplicate name. example: Johnny has 1 site that has 2 acres and another site that has 2 acres. I would like to find or index johnny’s duplicates and then total up the number of acres.

January 15, 2013 at 2:38 pm
(2) netizennewbie says:


Leave a Comment

Line and paragraph breaks are automatic. Some HTML allowed: <a href="" title="">, <b>, <i>, <strike>

©2014 About.com. All rights reserved.