1

I have 2 columns (with a yes/no choice) and want to add a third calculated column (based on column 1 and 2) that will automatically says "yes" only if both columns are set to "yes" and "no" if that is not the case.

Anybody and idea?

Thanks, Vincent

0

use this formulating =IF(col1=TRUE,IF(col2=TRUE,"Yes","No"))

you can read more about it here

and for Yes/No columns it would be like =IF(col1=TRUE,IF(col2=TRUE,IF(col3=TRUE,"Yes","No")))

  • Thanks That works. How does it work with multiple columns? Lets say 3 columns with yes/no? I red the article but I can't figure out how to do it.. – Vin01 Nov 12 '18 at 12:27
  • Thanks That works. How does it work with multiple columns? Lets say 3 columns with yes/no? I red the article but I can't figure out how to do it.. – Vin01 Nov 12 '18 at 12:32
  • @Vin01 i updated my answer – Melad Francis Nov 12 '18 at 12:37
  • 1
    What will be returned if column 1 is false? – Ganesh Sanap Nov 12 '18 at 12:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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