Numbers, Have a Checkbox Automatically Check

If you're new to Numbers you can find a lot of helpful information in the User Guide at Help > Numbers Help in your menu. Also helpful are Help > Formulas and Functions Help and the templates at File > New in your menu. Some of the templates use Checkbox.

Checkbox is a handy way to enter true or false and then display what you have entered. But it cannot be used to automatically display true or false depending on the value in another cell.

To display a visual checkmark based on, say, the value in B2 you could use a formula something like this:

=IF(B2>=5,"✓","")

That tells Numbers then display the ✓ character if the value in B2 is greater than or equal to 5, otherwise display nothing.

But that cell is just cosmetic. It can't be used for further calculations.

I typically would just use =B2>=5. . That automatically results in TRUE or FALSE, which can be used for further calculations.

SG

Spreadsheet software now goes back decades. It's designed so that you can enter a value in a cell, or you can enter a formula that will set its value. You can't have it both ways. If you want to display a result then you can try the formula that gives you as visual ✓ .

SG