Statement that returns pass, fail, ""
Closed
dooley
-
Jan 26, 2017 at 10:07 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jan 26, 2017 at 10:57 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jan 26, 2017 at 10:57 AM
Related:
- Pass fail marksheet result formula in excel
- Excel marksheet formula - Guide
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- The system time is invalid. this may be a result of a loss in battery power ✓ - CPU & Desktop Forum
- Logitech formula vibration feedback wheel driver - Download - Drivers
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Updated by TrowaD on 26/01/17 at 11:15 AM
Updated by TrowaD on 26/01/17 at 11:15 AM
Hi Dooley,
Try this formula:
=IF(COUNTIF(X7:AF7,"")=9,"",IF(COUNTIF(X7:AF7,"<="&AH4)=9,"pass","fail"))
Best regards,
Trowa
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.
Try this formula:
=IF(COUNTIF(X7:AF7,"")=9,"",IF(COUNTIF(X7:AF7,"<="&AH4)=9,"pass","fail"))
Best regards,
Trowa
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.
