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

Formulate cell either text, number or blank
Blank facebook page ✓ - Facebook Forum
Blank Facebook white screen ✓ - Facebook Forum
After logging into Facebook it shows blank page - Facebook Forum
If cell contains text then return value in another cell ✓ - Excel Forum
If a cell contains any text then add a value ✓ - Excel Forum

1 response

Answer 1 / 1

rizvisa1
Jan 31, 2010 at 07:09 AM

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

Similar discussions

Excel - IF function with multiple words

How to use conditional format based on text?

Counting cells containing only numbers

Highlight cell if another cell contains any text

Highlight cell if another cell contains specific text

Similar discussions

Subscribe To Our Newsletter!