Check cell content.

[Rumburak]

Hi,

In Excel2010
How can I identify with a formula, if a cell contains a formula, or a written, text or number?

Thanks.

 

[baitmaster]

=IF(ISFORMULA(A1),"formula",IF(ISBLANK(A1),"blank",IF(ISNUMBER(A1),"number","text")))

 

[Rumburak]

I'm afraid there is no ISFORMULA in excel 2010.

 

[baitmaster]

Well that's not very helpful is it?!

You could maybe recreate one as a UDF, though this isn't a perfect solution
pasted into a standard VBA module:

Function IsFormula(rng As Range) As Boolean
If Left(rng.Formula, 1) = "=" Then IsFormula = True
End Function

 

[Rumburak]

Thanks Baitmaster,

I'm not allowed to use VBA codes on my computer at work.
Maybe somebody will help me with a formula.

 

[baitmaster]

=IF(ISBLANK(A1),"blank",IF(LEFT(FORMULATEXT(A1),1)="=","formula",IF(ISNUMBER(A1),"number","text")))

FormulaText is not one I've ever needed before, you learn something new everyday...

 

[Rumburak]

I'm afraid there is no ISFORMULA in excel 2010.
Neither the FORMULATEXT function is in excel 2010

 

[mikerickson]

You might use GET.CELL https://www.mrexcel.com/forum/excel-questions/20611-info-only-get-cell-arguments.html

 

[Jaafar Tribak]

I'm afraid there is no ISFORMULA in excel 2010.
Neither the FORMULATEXT function is in excel 2010

Have you considered using a named formula via the GET.CELL function with type 48 ... No VBA required.

Just do a search for :
=GET.CELL(48,INDIRECT("rc",FALSE))

 

[Rumburak]

@mikerickson
@Jaafar Tribak

Thank you.