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?
Voice message downloader - Guide
Encryption And Decryption - Download - Encryption and decryption
Chat gpt for pc - Download - Other
Send popup message to another computer on network windows 10 - Guide
Do message requests on instagram expire - 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

using web browser page loads but screen blank

Message cannot be saved as draft (Yahoo attachments)

Formula to Find&replace blank cells in excel

Similar discussions

Subscribe To Our Newsletter!