Checking source of value in cell.

[bebo021999]

I would like to check if value in cell A1 is typed directly or calculated from

a formula:

Ex: A1 = 2 ==> B1 = TRUE

A1 = 1+1 ==> B1 = FALSE

Is there any formula in B1 can do that? (without VBA)

Thanks in advance.

 

[jbeaucaire]

No, those examples are both formulas. There is no worksheet function that can evaluate the content of a formula in another cell, only the displayed value.

Now, with VBA, one could probably construct one, but then... that's VBA.

 

[asking]

Check this URL

http://j-walk.com/ss/excel/tips/tip62.htm

Cheers

 

[Marcelo Branco]

Maybe using GET.CELL xml function

1. Create a named formula

Formula > Names Manager > New

Name: HasFormula
Refers to: =GET.CELL(48,INDIRECT("RC[-1]",FALSE))
Ok, Close

2. in B1
=HasFormula=False

HTH

M.

 

[mikerickson]

Wouldn't selecting A1 and looking at the formula bar be sufficient?
What is the goal of this tool(?) ?