Forum Discussion
Ricky Yates
Aug 02, 2017Copper Contributor
Excel Formula
I have a cell with a check box inserted and with cell link it will insert True or False into another cell depending on if it is checked or not but I need it to insert a number. Anyone know how to acc...
Haytham Amairah
Aug 02, 2017Silver Contributor
Hi Ricky,
Why you need it to insert a number?
What's your goal?
In fact, checked state in the check box represents only TRUE, and the unchecked represents only FALSE.
It's either TRUE or FALSE.
But, you can change TRUE to 1, and FALSE to 0 as the below example: