Excel: CELL() Function in 2.20 Behaves Differently from 1.50

• Microsoft Excel for the Macintosh, versions 1.x, 2.2, 3.0, 4.0

SUMMARY

The CELL() function returns information, such as formatting and location, about a cell. The syntax is CELL(type_of_info,reference). The syntax for versions 3.00 and 4.00 is CELL(info_type,reference).

In Microsoft Excel version 1.50, if the reference is left out, the program assumes that the formula references the cell that the formula resides in.

In Microsoft Excel version 2.20, if the reference is left out, the program assumes that the formula references the current active cell. Thus, when the worksheet recalculates, the value returned will reflect the cell that was active at the time of calculation. To return information about the cell in which the formula resides, include the reference to that cell in the CELL formula.

In Microsoft Excel version 3.00, if the reference is omitted, it is assumed to be the active cell. If reference is a multiple selection, CELL returns the #VALUE! error value.

In Microsoft Excel version 4.00, if the reference is omitted, it is assumed to be the active cell. If reference is a nonadjacent selection, CELL returns the #VALUE! error value.

In Excel versions 3.00 and 4.00, if you need to use cell information in a macro, GET.CELL provides a broader set of attributes.