# Calculated (calculation based on other columns)

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

## 1 Answer

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.. Commented Nov 12, 2018 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.. Commented Nov 12, 2018 at 12:32
• @Vin01 i updated my answer Commented Nov 12, 2018 at 12:37
• What will be returned if column 1 is false? Commented Nov 12, 2018 at 12:51