You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
My query simplifies down to this:
Cell A1 shows how much somebody owes
Cell B1 shows how much they have paid
Cell C1 is simply a checkbox to show those who have fully paid.
So what I want to achieve is this:
If A1 = B1 then automatically set the checkbox in C1 to be ticked
Otherwise set the checkbox in C1 to be Unticked.
Is this possible with Numbers (Mac) because I can't figure it out.
Many thanks - Stephen
MacBook Air 13″, macOS 12.3
The Checkbox Data Format is typically used for user input, and cannot be set by formula.
But you can display a checkmark when your condition is met, like this:
=IF(B2≥A2,"✓","")
Or, if your region uses , as a decimal separator:
=IF(B2≥A2;"✓";"")
If want to use another checkmark symbol instead you can find them here (or the equivalent in your region).
If you don't see that you may need to go to System Preferences > Keyboard > Input Sources and check Show Input menu in menu bar.
SG
The Checkbox Data Format is typically used for user input, and cannot be set by formula.
But you can display a checkmark when your condition is met, like this:
=IF(B2≥A2,"✓","")
Or, if your region uses , as a decimal separator:
=IF(B2≥A2;"✓";"")
If want to use another checkmark symbol instead you can find them here (or the equivalent in your region).
If you don't see that you may need to go to System Preferences > Keyboard > Input Sources and check Show Input menu in menu bar.
SG
You can make a background image of an unchecked checkbox and use the formula SGIII gave. I took a screenshot of a cell with a checkbox, edited it in Preview (cropped it, resized it to fit properly when set as a cell background of "original size"), and used it as the background. The text size for the cell needs to be the same as the other text in the row (or whatever size should be used based on the row height) for it to fit in the box correctly. The checkbox in the screenshot is the typical Helvetica Neue, Bold, 10pt. The cell text is set to center justification in both vertical and horizontal directions so the check stays is in the middle. It stays aligned with the box even when the cell is made wider and/or taller, unless you make is so short the font size does not fit.
You might consider using a bold capital X instead of a checkmark. Same setup, just with an X. It is a little more visible than a checkmark of the same size font.
Many thanks for your speedy and helpful reply. It would have been nice to use the checkbox, but your solution gives me what I need.
Best wishes
Stephen
Conditional setting of a checkbox in Numbers (Mac)
