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

Question:

Question: 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

Reply
Question marked as Apple recommended
Answer:
Answer:

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

Posted on

User profile for user: vontina

Question: If a checkbox is checked