Formulate cell either text, number or blank

Closed
Report
Posts
1
Registration date
Saturday January 30, 2010
Status
Member
Last seen
January 31, 2010
-
 rizvisa1 -
Hello,
Am trying formulate excel cel A – like this
If cell A = 12 than is 12
if its txt then its txt
if its blank then its blank

please help me with this formula many thanks

1 reply

you mean like this
=IF(A1=12, 12 ,IF(ISTEXT(A1),"Text",IF(ISBLANK(A1),"Blank","None of the above")))
0