Display a text when a certain cell is answer
Closed
dmcswine
-
May 31, 2010 at 02:54 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 31, 2010 at 05:55 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 31, 2010 at 05:55 AM
Related:
- Display a text when a certain cell is answer
- How to answer call with volume button android - Guide
- To display a text file in reverse order what command should be used - Guide
- Download mp3 with lyrics display - Download - Audio playback
- Huawei display check code - Guide
- Based on the values in cells b77 b81 answer ✓ - Excel Forum
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 31, 2010 at 05:55 AM
May 31, 2010 at 05:55 AM
Not know what your meant by "answer, hope this helps
=IF(IF(a1="", "", IF(A1=5, "Yes", "no"))
this formula is saying
if A1 = blank then show nothing
If a1 is 5 then show YES
if a1 not equal to 5 then show "No"
=IF(IF(a1="", "", IF(A1=5, "Yes", "no"))
this formula is saying
if A1 = blank then show nothing
If a1 is 5 then show YES
if a1 not equal to 5 then show "No"
