Forum Discussion

Ricky Yates's avatar
Ricky Yates
Copper Contributor
Aug 02, 2017

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 accomplish this?

excel

2 Replies

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Aug 02, 2017

    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:

     



     

     

     

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Aug 02, 2017

    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.