ISFORMULA

Checks whether a cell contains a formula.

Syntax

=ISFORMULA(reference)

Example:

If B2 contains:

=A2*10

then:

=ISFORMULA(B2)

returns:

TRUE

If B3 contains manually entered text:

=ISFORMULA(B3)

returns:

FALSE

Real-World Uses

  • Checking formula cells
  • Auditing worksheets
  • Protecting calculated columns
  • Identifying manually entered data

TYPE

Returns a number representing the type of data.

Syntax

=TYPE(value)

Common results:

Result

Data Type

1

Number

2

Text

4

Logical value

16

Error

Example

=TYPE(100)

Result:

1

=TYPE(“Excel”)

Result:

2

CELL

Returns information about a cell.

Syntax

=CELL(info_type,[reference])

Example:

=CELL(“address”,A2)

Returns the cell address.

Another example:

=CELL(“row”,A2)

returns the row number.

Practice

Create a Worksheet Information Checker using ISFORMULA, TYPE, and CELL.

PreviousNext