Previous Topic Next Topic

Formulate cell either text, number or blank

Closed
cabdoo Posts 1 Registration date Saturday 30 January 2010 Status Member Last seen 31 January 2010 - 31 Jan 2010 à 05:46
 rizvisa1 - 31 Jan 2010 à 07:09
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
Related:

1 response

Réponse 1 / 1
rizvisa1
31 Jan 2010 à 07:09
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
measking -
HelpiOS -

1 response
Whatsapp web "chat to myself" not working
PeterDays -
Unknown -

31 responses
using web browser page loads but screen blank
inchoate -
leo -

16 responses
blank white page for website
yadaves -
ac3mark -

1 response
How can I make my name text invisible in Discord
imbenmark -
imbenmark -

4 responses