Value text and blank

Closed
Report
-
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
-
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

2 replies

=IF(A1=12, 12 ,IF(A1="SICK", "SICK",IF(ISBLANK(A1),"Blank","None of the above")))
0
Posts
138
Registration date
Thursday January 21, 2010
Status
Member
Last seen
May 8, 2019
7
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
0