I need column1 to determine the value of column2.

So If column1 equals yes column2 needs to equal yes;


If column1 equals no then column2 should equal no

1 Answer 1


You can do it as


Since you said if column1 = yes the column2 = yes

If you are looking for more logic.. then the conditional logic goes as

=if(column1="Yes", "Yes", "No")

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.