Calculate percentage based on checkbox results in Numbers iOS

Using Numbers iOS, I've created a gradebook to keep track of my students' progress.


I have used the Checkbox format for my results, and I would like to create a formula that will calculate a percentage based off of the checked results.


What formula could I use to convert the TRUE and FALSE results from my checkbox cells into 1s and 0s, add up the score, and then convert the total score into a percentage?


I've attached a picture to help explain what it is I'm trying to do here. I'd like to keep the checkboxes cells as checkboxes and only have the results converted in the "Grade" Column.

User uploaded file


Thanks for your help!

Numbers iOS-OTHER, iOS 8.1

Posted on Nov 3, 2014 6:27 AM

Reply
4 replies

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Calculate percentage based on checkbox results in Numbers iOS

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.