Hi,

Excel only provides that capability via VBA. You could write a VBA Function.

Here is a very basic example:

Function AFormula(cell As Range)
AFormula = cell.HasFormula
End Function


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Joe" wrote:

how do you do an if statement to check if a cell contains a value like a
number or a formula?