G
Guest
Greetings,
I am new to check boxes and have a quick question.
I would like to place a value of a cell that is next to a checkbox in
another cell with a formula such as IF(A1,A2,"") where A1 is my checkbox, A2
is the value that I would like to place in the cell where this formula
resides if the check box is checked, and if it is not checked to leave the
cell blank.
I can't seem to do this however. I have also used IF(A1=0,A2,"").
Anyone have any ideas?
Thanks for your help!
I am new to check boxes and have a quick question.
I would like to place a value of a cell that is next to a checkbox in
another cell with a formula such as IF(A1,A2,"") where A1 is my checkbox, A2
is the value that I would like to place in the cell where this formula
resides if the check box is checked, and if it is not checked to leave the
cell blank.
I can't seem to do this however. I have also used IF(A1=0,A2,"").
Anyone have any ideas?
Thanks for your help!