=ISFORMULA(A1) ?

[eliW]

Is there in Excel any function to check if a cell contains a formula, like for example =ISNUMBER(A1) or ISTEXT(A1)?
Eli
This message was edited by eliW on 2002-04-08 14:35

 

[Aladin Akyurek]

On 2002-04-08 14:29, eliW wrote:
Is there in Excel any function to check if a cell contains a formula, like for example =ISNUMBER(A1) or ISTEXT(A1)?
Eli

No. It's not too difficult though to set up a UDF. I might add that such a built-in function would be a totally different beast among the IS-functions which all directed at values in a cell, not at the underlying generator of values.

Aladin

 

[eliW]

Thank you Aladin,
It would be very useful though.

 

[Jay Petrulis]

Hi,

Could not get the Excel TYPE(Value) function to test True for 8 (the formula), but here is an UDF that works.

-----------------------
Function IsFormula(RefCell As Range)
If RefCell.Cells.Count <> 1 Then
IsFormula = CVErr(xlErrValue)
Else
IsFormula = RefCell.HasFormula
End If
End Function
-----------------------

Returns True or False. Called as
=ISFORMULA(A1)

Should work with other functions.

HTH,
Jay

 

[Mark W.]

On 2002-04-08 14:29, eliW wrote:
Is there in Excel any function to check if a cell contains a formula, like for example =ISNUMBER(A1) or ISTEXT(A1)?
Eli
This message was edited by eliW on 2002-04-08 14:35

You could cheat!!

1. Enter =A2+2 into cell A1.
2. With cell B1 selected setup a defined name, Has_Formula, that refers to...

=GET.CELL(48,A1)

Now, you can enter the formula, =Has_Formula, in any cell to see if the cell to its left contains a formula. =Has_Formula will return TRUE or FALSE.
This message was edited by Mark W. on 2002-04-08 16:19