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?
How Can I Undo Seen Message Into Unseen Message On Instagram ✓ - Instagram Forum
Encryption And Decryption - Download - Encryption and decryption
Sophos free encryption - Download - Encryption and decryption
Blank discord name ✓ - Internet & Social Networks Forum
How to update dates in Excel spreadsheet: formula - 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

using nested if to blank out adjacent cells

blank white page for website

Similar discussions

Subscribe To Our Newsletter!