Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Level 1

4 points

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?

Posted on May 25, 2018 4:47 PM

Best reply

Level 8

35,264 points

Posted on May 25, 2018 6:40 PM

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.

View in context

Similar questions