If statement to determine if value is = to text string or numeric

[jlugo]

Hi

What is a formula or way I can write to determine if this is a text string(any text) then do this.
If not, if numeric value, do that?

 

[jlugo]

Or, can an if statement condition verify if the cell value is in a specific cell location (if cell is located in A2 or A3 do this)?

 

[jasonb75]

Test with a simple function.

=IF(ISNUMBER(A1),...
=IF(ISTEXT(A1),...

 

[jlugo]

Excellent! Thanks Jason. What about a test to verify the cell location?

 

[jasonb75]

Maybe something on the lines of

=IF(A2=??

There are too many possibilities to give an accurate answer without more information.