Value text and blank

Closed

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

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? ✓ - Android Forum
Using web browser page loads but screen blank ✓ - Network Forum
Laptop blank screen asus - Laptop Forum
Blank white page for website - Google Chrome Forum
IF statements with dates and criteria ✓ - Excel Forum

2 responses

Réponse 1 / 2

rizvisa1
31 Jan 2010 à 07:13

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

Réponse 2 / 2

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

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

How can I make my name text invisible in Discord

encryption message several time in chat

My Facebook Page is Loading Blank

Whatsapp web "chat to myself" not working

Laptop screen blank when switched on

Similar discussions

Subscribe To Our Newsletter!