Without using a UDF is there a function you can use to return true if a
formula is in a cell??
Thanks,
Without using a UDF is there a function you can use to return true if a
formula is in a cell??
Thanks,
XLM:
1. Press Ctrl+F3 and define a name "isformula" (no quotes)
as:
=LEFT(GET.FORMULA(INDIRECT("RC[-1]",FALSE)))="="
2. Now call it in a cell like this:
=isformula
Some notes:
1. It will evaulate the cell to the immediate left.
2. It will return TRUE in cases like =7 where an equal
sign is not necessary.
3. There is some risk involved with using this method.
Please read:
http://tinyurl.com/3jsqt
HTH
Jason
Atlanta, GA
>-----Original Message-----
>Without using a UDF is there a function you can use to
return true if a
>formula is in a cell??
>
>Thanks,
>.
>
Jason Morin wrote...
>XLM:
>
>1. Press Ctrl+F3 and define a name "isformula" (no quotes)
>as:
>
>=LEFT(GET.FORMULA(INDIRECT("RC[-1]",FALSE)))="="
....
In what conceivable alternative universe would this be preferable to
=GET.CELL(48,INDIRECT("RC[-2]",0))
?!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks