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

Different dates of "end to end encryption message" on blank chat?
Do message requests on instagram expire - Guide
How to message yourself on WhatsApp: Android, iPhone - Guide
You can't message this account unless they follow you - Instagram Forum
Blank discord name ✓ - Internet & Social Networks Forum
Msn chat history - Guide

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

encryption message several time in chat

Whatsapp web "chat to myself" not working

blank white page for website

using web browser page loads but screen blank

A random chat ALWAYS top of my facebook messages on desktop

Similar discussions

Subscribe To Our Newsletter!