Formula which calculates the percentage of these cells
Closed
Lucy
-
Mar 17, 2015 at 10:59 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Mar 23, 2015 at 12:54 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Mar 23, 2015 at 12:54 PM
Related:
- Formula which calculates the percentage of these cells
- Excel marksheet percentage formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Vat calculation formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Mar 23, 2015 at 12:54 PM
Mar 23, 2015 at 12:54 PM
Hi Lucy,
Try this formula:
=(COUNTIF(H10:H46,"<=-0,4")+COUNTIF(H10:H46,">=0,4"))/16
Don't forget to format your formula cell as Percentage to get the desired result.
Best regards,
Trowa
Try this formula:
=(COUNTIF(H10:H46,"<=-0,4")+COUNTIF(H10:H46,">=0,4"))/16
Don't forget to format your formula cell as Percentage to get the desired result.
Best regards,
Trowa