If a checkbox is checked
I am trying to figure out a formula for this scenario..
I want to set D1 to equal the value in C1 if the checkbox in A1 is checked.
Can anyone helps me out?
I am trying to figure out a formula for this scenario..
I want to set D1 to equal the value in C1 if the checkbox in A1 is checked.
Can anyone helps me out?
You can try this in D1:
=IF(A1,C1,"")
This will show the value in C1 if the checkbox is checked and blank (the "") if not checked.
SG
There are no replies.
If a checkbox is checked