Excel 2007 ISBLANK Function
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
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.