Timeline for If A = 2, then set B to yes
Current License: CC BY-SA 4.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 3, 2020 at 17:17 | comment | added | willman |
Yes, although you probably have to put the column name in square brackets, like =IF([Functie]="Stagiair", TRUE, FALSE)
|
|
| Mar 3, 2020 at 16:16 | comment | added | Mirte | I cannot get this to work. After I try to save it, it says that the formula has an syntaxerror. The column A is called Functie, and one of the values to choose from is Stagiair. So the're strings. I This should do it, right? =If(Functie="Stagiair",TRUE, FALSE) | |
| Mar 3, 2020 at 11:39 | history | answered | willman | CC BY-SA 4.0 |