If function question

[stevendebuf2035]

I am looking for the following.

I want to use the if function as follow:

condition : if cel a = a number than cel b = value 1

if cel a = text than cel b = value 2

Tnx for the help

[#2 · Accepted solution]

@stevendebuf2035 

Perhaps

=IF( ISTEXT(A1), <value2>, <value1> )

[#3]

Hai ,
Place the formula =IF(ISNUMBER(CELL a) , Value 1,Value 2)
Place the formula in the CELL b
If the Result values are not numbers type them in Double Colons(" Value ")