Hi

If a cell A1 contains the formula (for example, =SUM(K2:K1000) ),
Select a cell B1, from the formula menu, choose [Define Name].

In the Name box, type a name HASFORMULA and In the Refers To box,
type a formula =EVALUATE(GET.CELL(48,!A1)), and choose
the [Add] button and then [Close] button.

In a cell B1, enter the formula:

=HASFORMULA

--
Regards,

Soo Cheon Jheong
Seoul, Korea
http://excel.hompy.com
_ _
^¢¯^
--