3.5.7.20 IsFormula

IsFormula-func

Description

This function is used to determine whether a worksheet cell contains cell formula or not. It is useful in Set Values dialog box only.

Syntax

int IsFormula(string str)

Parameters

str

is a worksheet cell address in Spreadsheet Cell Notation syntax.

Return

If the cell contains a cell formula, the function returns 1, otherwise returns 0.

Examples

isformula(B1)=; // return 1 if 1st row of col(B) contains cell formula, otherwise return 0