Excel formula!
Solved/Closed
I would like to make an excel formula that
if at least 7 out of 10 cell (i.e A1 to A10) are greater than 5, then return as " accepted", otherwise "no".
if at least 7 out of 10 cell (i.e A1 to A10) are greater than 5, then return as " accepted", otherwise "no".
Related:
- Excel formula!
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel mod apk for pc - Download - Spreadsheets
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Apr 29, 2010 at 08:50 AM
Apr 29, 2010 at 08:50 AM
TRY THIS
=IF(COUNTIF(A1:A10,">5")>=7,"ACCEPTED","NO")
Apr 29, 2010 at 11:49 AM