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?
Message request on instagram disappeared - Guide
Sophos free encryption - Download - Encryption and decryption
Different dates of end-to-end encryption message on blank chat whatsapp - Excel Forum
Random chat - Facebook Messenger 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

using web browser page loads but screen blank

blank white page for website

How can I make my name text invisible in Discord

Similar discussions

Subscribe To Our Newsletter!