Value text and blank

Closed

abdi - Jan 31, 2010 at 04:50 AM
Game Start Now Posts 138 Registration date Thursday January 21, 2010 Status Member Last seen May 8, 2019 - Jan 31, 2010 at 11:04 AM

Hello,
Am trying formulate excel cel A – like this
If cell A = 12 than is 12 if its sick then sick if its blank then its blank please help me with this formula many thanks

Value text and blank
Blank facebook page ✓ - Facebook Forum
Blank white square ✓ - Monitor Forum
Messenger is blank white screen pc - Facebook Forum
Website loads but is blank ✓ - Network Forum
Mecer laptop screen blank - Monitor Forum

2 responses

Answer 1 / 2

rizvisa1
Jan 31, 2010 at 07:13 AM

=IF(A1=12, 12 ,IF(A1="SICK", "SICK",IF(ISBLANK(A1),"Blank","None of the above")))

Answer 2 / 2

Game Start Now Posts 138 Registration date Thursday January 21, 2010 Status Member Last seen May 8, 2019 7
Jan 31, 2010 at 11:04 AM

If You Type 1 In (A1) Then It Shows 1, If You Type Sick In (A1) Then It Shows Sick, If (A1) = Blank Then It Don't Show Anything...

=IF(ISBLANK(A1),"",A1)

Regards,
Naeem

Similar discussions

My Facebook Page is Loading Blank

Formula to Find&replace blank cells in excel

blank Facebook white screen

after logging into Facebook it shows blank page

Cannot login to facebook, only get blank page

Similar discussions

Subscribe To Our Newsletter!