Display a text when a certain cell is answer
Closed
dmcswine
-
31 May 2010 à 02:54
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 31 May 2010 à 05:55
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 31 May 2010 à 05:55
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
- Internet explorer cannot display the webpage - Guide
- Skype auto answer - Guide
- Computer turns on but no display - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
31 May 2010 à 05:55
31 May 2010 à 05:55
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"
