Find Formula

[kenthehead]

I need to find out whether a cell contains a formula or an entered text value and place the result in the adjacent cell

e.g
ABC Text
=A+B Formula
etc, etc

I would prefer the answer as a formula and not VBA code

Thanks in advance

Much appreciated

Cheers

Ken

 

[Peter_SSs]

Thanks for that link - very interesting.
I am puzzled by the cell reference "!A1" can you point to help on that?
Thanks
I tested your solution on XL2003 and worked as expected.

Mike Girvin suggested this method to me recently at the end of this thread

 

[John Davis]

John

To be honest, I don't remember ever seeing the ISNONTEXT() function before.

However, I don't think it is up to this job, at least in some circumstances. In the sheet below
C1 contains directly entered text
C2 contains a formula

ISNONTEXT doesn't distiguish between them.

Similar situation where numbers are involved. The function doesn't distinguish between the formula and the non-formula

Excel Workbook
	A	B	C	D
1	*	*	Tim Brown	FALSE
2	Tim	Brown	Tim Brown	FALSE
3	*	*	*	*
4	*	*	5	TRUE
5	2	3	5	TRUE
Test

Good Observation Pete:

I only tested in a few instances. I should have tested it further. It seemed like it should have worked.