Blank Cells and ??? Cells
Blank cells are simply empty cells. They appear only at the end of a column or in empty columns. Blank cells and ??? cells are treated differently by different macro functions. Most macro functions treat blank cells as zeros and signal and propagate errors in ??? cells with the following exceptions:
*
The MAXINDEX macro function ignores both blank cells and ??? cells.
*
The OFFSET macro function ignores blank cells and ??? cells.
*
The DDELINK macro function passes on blanks and ??? cells.
*
For macro functions that skip blank cells, see Use of Constants. Errors in ??? cells are still signaled and propagated.
*
For macro functions that skip blank cells, but use ??? cells as described, see Macro Functions That Skip Blank and Use ??? Calls.
*
For macro functions that will return ??? for all cells if any of the cells in the listed arguments contain ???, see Macros Functions That Cannot Process ??? Cells.
Copyright IBM Corporation 2015. All Rights Reserved.