Hi,
Apologies if this is a simple one.
I'm trying to get a formula on Mac that will check a checkbox if a value in another cell hits a certain number.
e.g. if greater than 100 check if not remain unchecked.
Thanks
Hi Rob,
A checkbox can not be made to change by a formula.
Perhaps you could try something like this:
=IF(B2>100,"Yes","No")
Regards,
Ian.
Adding to Ian's response, you can use a unicode character for a checkmark instead of the word "yes". And you can use a combining character to create the box.
=IF(B>100,CHAR(10003)," ") & CHAR(8414)
Unicode 10003 (hex 2713) is a checkmark
Unicode 8414 (hex 20DE) is a combining character that looks like a square. It combines with the previous character to create a whole character.
Two addendums/caveats to my earlier post:
1) I happened to look at my document in iCloud and it was not combining the characters as it should. The box and checkmark were displayed as separate characters. So you might be better off using the checkmark without the box. Or maybe use an image of a box as an image fill for the cell. It, too, might not show up in iCloud (or if exported to Excel) but it would be better to have the box disappear than to have a box that is out of place.
2) For some reason, an "empty" box will not align with a checked box. Maybe there is some kind of "invisible" character that will combine with it to align it properly but I'm not finding one.
Seems like you would be better off not having the box, just having a checkmark, or lack thereof.
Checkbox Formula
