View Single Post
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

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,
.