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
If cell contains specific text then return value in another cell ✓ - Excel Forum
Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
If cell contains date then return value ✓ - Office Software Forum
Compare 2 text cells and show difference in the third cell ✓ - Excel Forum
Excel conditional formatting if another cell contains specific text ✓ - 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

Counting cells containing only numbers

Formula to Find&replace blank cells in excel

How to use conditional format based on text?

Excel - IF function with multiple words

Highlight cell if another cell contains specific text

Similar discussions

Subscribe To Our Newsletter!