Excel Calculation | I want to know the formula which returns the answer about ‘formula or number’?

I would like to know the formula which returns a better solution about ‘formula or perhaps number’
Example

A1 = 10
A2 = 2

if A3 has =A1*A2 it is going to return cost 20.
now in case A3 features typed cost 20 besides a system =A1*A2

There has to be any job which conveys to that A3 includes a formula (=A1*A2) or perhaps a price (20).

I know there exists a formula inspector to find out the formulation but i would like a Accurate or Phony, 1 or maybe 0 similar to info.

Thanks before hand for ones help

Hassan Javed

You can cause your personal Function
With VBA Stand out we identified as it:customer Defined Operate / UDF

Touch Alt +F11
Palate:Insert > Module
kind this rule:
‘——————-
Job IsFormula(X Because Range) When Boolean
IsFormula = TIMES.HasFormula
Ending Function
‘———

Backto worksheet (Alt + F11 again)
You can now type some sort of formula with B3
=Isformula(A3)

This kind of function results TRUE.

Leave a Reply