Formulate cell either text, number or blank

Closed
cabdoo Posts 1 Registration date Saturday January 30, 2010 Status Member Last seen January 31, 2010 - Jan 31, 2010 at 05:46 AM
 rizvisa1 - Jan 31, 2010 at 07:09 AM
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