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
Different dates of "end to end encryption message" on blank chat? ✓ - Network Forum
Tiktok blank page - TikTok Forum
Webpage blank - Internet & Social Networks Forum
Using nested if to blank out adjacent cells - Excel Forum
Blank character discord ✓ - Internet & Social Networks 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

encryption message several time in chat

blank white page for website

IF statements with dates and criteria

Formula to Find&replace blank cells in excel

My Facebook Page is Loading Blank

Similar discussions

Subscribe To Our Newsletter!