Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Giving a checkbox numerical value

Can I give checkboxes a numerical value? I am trying to create a new payroll spreadsheet and I want to use checkboxes. If I click a checkbox I want it to represent like 8 hours and if I don't I want it to represent 0 and then I want it to total the value at the end. Is that possible in numbers? If so can someone please tell me how.

MacBook Air 13", macOS 10.14

Posted on Nov 6, 2019 8:12 PM

Reply
Question marked as Best reply

Posted on Nov 6, 2019 9:25 PM

Hi donasia,


Formula in Footer cell B8 =COUNTIF(B,"=TRUE")×8


Regards,

Ian.

2 replies

Giving a checkbox numerical value

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