« Toolbar Crazy | Main | Entering Dates Quickly »
January 30, 2006
Returning a Blank rather than Zero or Error
In the spreadsheet below, we wish to apply a formula to the values of a particular column - C and display the results in column D. However, the column is 'sparse' in that not all cells in the column have values.This would be problematic if the formula returns an error when applied to a blank cell. However, by incorporating the ISBLANK function as shown below, we can gurantee that only non-blank entries are processed.
Posted by Dave at January 30, 2006 02:14 PM