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...
SergeiBaklan
Aug 02, 2017Diamond Contributor
Hi Ricky,
Linked cell always returns TRUE or FALSE (perhaps behaviour could be changed by VBA). You may link the cell somewhere outside of your data range and use IF on that cell to put this or that into your data cell.