How do I create conditional checkboxes in Numbers?

In Numbers I want to have three check boxes where:

  • if you check box one then box one is checked
  • if you check box 2, then both box one and box 2 are checked
  • if you check box 3 than all boxes 1-3 are checked


I am having a hard time for the syntax of the IF,Than formula.


Any help would be most appreciated.



[Re-Titled by Moderator]

Original Title: Numbers, Checkboxes, and Forumlas

Posted on Jun 28, 2025 01:44 PM

Reply
1 reply
Sort By: 

Jun 28, 2025 08:12 PM in response to MacNoobRAWshooter

Hi MacNoobRAWshooter,


No. We can't force a tickbox to adopt a TRUE/FALSE state.

However, we can use other cells with formulas to adopt TRUE/FALSE text.



Formula in B3 is IF(OR(B2=TRUE,C2=TRUE,D2=TRUE),"True","False")

Formula in C3 is IF(OR(C2=TRUE,D2=TRUE),"True","False")

Formula in D3 is IF(D2=TRUE,"True","False")





Regards,

Ian.

Reply

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.

How do I create conditional checkboxes in Numbers?

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