CELL Function in Zoho Sheet: Syntax, 12 Selectors, Examples and Errors

=CELL(info_type; cell_ref)

info_type (required): a quoted text selector, such as "ADDRESS", "COL", or "CONTENTS". Zoho documents 12 selectors; case-insensitive acceptance is not established in the page, so reproduce the uppercase forms shown. cell_ref (required): the reference of the cell to inspect, such as B4 or, when using CONTENTS, a range such as B4:B6. No optional arguments or defaults are documented. Do not put a literal string "B4" in place of the reference unless you have separately verified that operation; the official syntax calls for a reference.

CELL returns different kinds of results depending on info_type: numbers for row/column and certain flags, text for addresses, labels and format descriptions, and a cell’s actual content for CONTENTS. That variability is why a worksheet can show the metadata as text without applying any transformation to the original cell. The official Zoho article specifies these semantics.

Zoho also identifies format codes for numeric, percentage, currency, exponential, dates and times: , means thousands-separated numeric format; F plain numeric; C currency; S exponential; P percentage; D1–D9 represent different documented date/time patterns; G covers other formats. Decimal counts may be appended to a code (its example interprets 10.000% as P3). A trailing - flags a number format coloring negative values, and () flags brackets in a format for positive values. These conventions should be read from Zoho’s original formatting table; don’t infer a code solely from a cell’s displayed text.

In an empty worksheet, enter the following actual inputs, leaving the named empty cells truly blank. Place results outside the listed input cells so formulas do not overwrite your dataset.

Use this table for reproducible checks:

The address format and CONTENTS’ upper-left selection are independently supported by Zoho’s published examples, including =CELL("ADDRESS";A2) producing $A$2 and =CELL("CONTENTS";A2:A4) returning that range’s first entry. Other rows above are deterministic reasoning from the documented selector definitions; all require confirmation in a real Zoho session.

Advanced example: build an audit companion column

Suppose column B holds a changing list of product codes and amounts. In C4, enter =CELL("TYPE";B4); in D4 enter =CELL("ADDRESS";B4); in E4 enter =CELL("CONTENTS";B4). Copy down to build a side-by-side report of storage class, location and original content. This is useful after importing a CSV whose apparent numeric entries may actually be text. It does not validate the business meaning of the value; use a separate validation rule for that.

For bulk formatting checks, a second audit column can use =CELL("FORMAT";B4) after you deliberately apply two different number formats. Do not hard-code a result: the code depends on the actual format and locale. For WIDTH, first set the default font and column widths; Zoho’s help gives an example width of 100, not a universal constant.

Advanced example: range semantics matter

=CELL("CONTENTS";B4:B6) returns the first cell, not all values. If B4 contains 27, changing B6 should not change that result while B4 remains unchanged. If you need every value, use direct references or an appropriate aggregation function; CELL is not an alternative to a range-processing function. Zoho documents CONTENTS separately from the single-cell metadata selectors.

These functions are named similarly but encode different classifications. CELL("TYPE";B4) reports a short letter code for the referenced cell’s contents: blank b, label/text l, or numeric v. TYPE(B4) instead reports a number describing the type of an input value (such as 1 for numeric or 2 for text; arrays and errors have codes too). Never copy CELL("TYPE") results into a table expecting numeric TYPE codes. This distinction is particularly valuable during formula-auditing.

• #NAME!: Confirm the name CELL is spelled correctly and the info selector is quoted, for example "ADDRESS". Zoho lists unquoted text, undefined names and mistyped formulas among common causes.
• #VALUE!: Check that info_type is a text string and cell_ref is a usable reference; Zoho lists incorrect data types as a possible source. The exact result of every unsupported selector string (such as "BOGUS") is not explicitly specified: verify it rather than promising a particular error.
• #REF!: A deleted or broken reference can produce an invalid-reference error; repair the source location before interpreting metadata.
• Unexpected WIDTH: It is measured using zeros in the default font, rather than arbitrary displayed characters; resizing the column can change the width.
• Unexpected SHEET: The sheet number is workbook-dependent. Test after moving or adding sheets instead of relying on a fixed position.
• Unexpected FORMAT: Check actual cell number formatting; visual appearance and built-in format codes are not equivalent to the raw underlying value.
• Multiple-cell input: Zoho explicitly describes upper-left behavior for CONTENTS, but does not comprehensively spell out range selection for every other selector. Use a single-cell reference for those selectors unless you test broader behavior.
• Blank-looking cells: A cell with a formula returning empty text may not be a truly blank cell; the vendor example does not establish how CELL("TYPE") classifies every such formula. Test before classifying imported records.

For reference-coordinate-only needs, COLUMN(cell_ref) and ROW(cell_ref) are narrower alternatives, separately documented by Zoho. For showing the formula itself as text rather than its result, FORMULA(cell) is a different, documented function.

Does CELL change a value? No; its documented purpose is to return information about a reference. If your results seem to modify data, examine the formula’s placement and any other formulas in the workbook.

Does it always return a number? No. "ROW"/"COL" are numeric, but address and type selectors return text, and "CONTENTS" can reflect the content of the inspected cell.

Can I use the width sample as a unit conversion? No. The help defines width using default-font zeros, which is not a universal pixel or character metric.

Is this an Excel compatibility guarantee? No. The list above comes from Zoho; test imported workbooks and formatting metadata separately.

• Zoho Sheet: CELL — syntax, all info selectors, formatting codes, vendor examples, errors (checked 2026-10-13).
• Zoho Sheet: COLUMN — separately documented reference-to-column function (checked 2026-10-13).
• Zoho Sheet: ROW — reference-to-row function (checked 2026-10-13).
• Zoho Sheet: TYPE — numeric type codes, distinct from CELL’s b/l/v codes (checked 2026-10-13).
• Zoho Sheet: FORMULA — retrieval of stored formula text (official article linked from information-function catalogue; checked 2026-10-13).

The linked function page is in Zoho’s public, English-language Zoho Sheet knowledge base, which documents the function in the current cloud spreadsheet product. It does not provide an official first-supported release number, a paid-plan minimum, or a tested matrix for Android, iOS, desktop beta, offline mode, and imported Excel/Google files. Therefore none is asserted here. Test the formulas in your actual account and platform before a production migration.

For arguments separated by semicolons, the syntax in this guide follows the English Zoho Help examples. Zoho provides per-user/spreadsheet locale and language preferences. If your account displays different function names or separators, choose them using that environment’s formula help/autocomplete rather than copying punctuation blindly. Numeric examples with no separator should generally be the easiest to verify.

Compatibility evidence: These pages establish Zoho-documented functionality only. Similar names in Excel, Google Sheets or LibreOffice are not evidence of identical coercion, errors, blank-cell treatment, array semantics, imported-formula translation, or formatting behavior. The differences that matter for this function are discussed above; otherwise, migration parity remains not independently validated.

• Documentation research: individual Zoho function Help checked 2026-10-13; related links verified against Zoho’s official Help listings and article pages.
• Expected answers: arithmetic/type rules reasoned independently, not copied from another spreadsheet’s execution. Vendor-given examples are identified.
• Native Zoho execution: NOT RUN. No account was connected; cloud, mobile and desktop behavior were not tested.
• Testing priority: paste each one-cell example, compare displayed results, then repeat on your target locale; test any cautioned blank/error/array cases separately.