Excel - IF Functions
Closed
Cde
-
Aug 13, 2010 at 05:41 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 17, 2010 at 11:24 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 17, 2010 at 11:24 PM
Related:
- Excel - IF Functions
- Excel marksheet - Guide
- Number to words in excel - Guide
- Excel apk for pc - Download - Spreadsheets
- Kernel for excel - Download - Backup and recovery
- Gif in excel - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Aug 17, 2010 at 11:24 PM
Aug 17, 2010 at 11:24 PM
You can use
=IF(OR(A2="", A2<=0), "", IF(AND(A2>0, MOD(A2-1,3)=0), "YES", "No"))
=IF(OR(A2="", A2<=0), "", IF(AND(A2>0, MOD(A2-1,3)=0), "YES", "No"))