Microsoft Office Tutorials and References
In Depth Information
Using the ISBLANK Function
Again, the IS functions alone provide only a TRUE/FALSE result. However, when used in
conjunction with other functions, they can be powerful management tools. Note some of the
following IS functions in use with others.
Using the ISBLANK Function
ISBLANK returns the value associated with the number of empty cells.
=ISBLANK(value)
The ISBLANK function can be used in accordance with the SUM and IF functions to track
information based on the input of dates within a cell. Note the formula as shown in Figure 7.5 in
cell I19:
This is the cell or range you want tested.
VALUE
{=SUM(IF(ISBLANK(I8:I18),0,$D$8:$D$18))} Ctrl+Shft+Enter to activate the array.
The formula looks up the cells with dates in them within the range and returns the actual page
count from the column D range. For example, let’s say you are tracking steps in a process. In
this case, the chapters in a topic have to go through four steps before being complete. When
you place a date completed in the intersecting cell for the chapter and step completed, the
formula takes into account the actual page count from column D and adds up the column. The
percent complete shows the total chapters complete through the steps.
A
ISBLANK range
Figure 7.5
Combine the
ISBLANK function
with SUM and IF to
lookup entered dates
in a range and return
a numeric result from
another range.
B
Numeric return range
ISNUMBER
ISNUMBER returns a value if the cell has a number.
=ISNUMBER(value)
Search JabSto ::




Custom Search