Returns information about the formatting, location, or contents of a cell.
פונקציה זו פועלת ב-Google Sheets בדיוק כמו ב-Excel — אותה תחביר ואותם ארגומנטים.
CELL(info_type, [reference])The CELL function is used to retrieve specific metadata about a cell, such as its address, row number, or formatting style. It is often used in complex formulas to track changes in a worksheet's structure or appearance.
=CELL("row", A1)תוצאה: 1
Returns the row number of cell A1.
=CELL("address", B5)תוצאה: $B$5
Returns the absolute address of cell B5.
No, the CELL function does not automatically recalculate when the formatting of the referenced cell changes; you must force a recalculation.