Forum Discussion
IF function - from 2 columns
It is True/Fals datatype and that was the problem
I just figured out that if i removed the ( " ) it worked, so:
= if [NI] = true and [DT] = true then "1" else "0"
Worked like a charm.
Ty very mutch for answering tho Ruksuro ;)
Hi,
Assuming you have this stored as a True/False datatype your code should read:
Test = if(and(Sheet1[ColumnA]=TRUE,Sheet1[ColumnB]=TRUE),1,0)
The "TRUE" you've used is a string (because of the quotes), not TRUE. I've just tested and this doesn't work.
If your data type is actually a string, use:
Test = if(and(Sheet1[ColumnA]="TRUE",Sheet1[ColumnB]="TRUE"),1,0)
Hope that helps!
It is True/Fals datatype and that was the problem
I just figured out that if i removed the ( " ) it worked, so:
= if [NI] = true and [DT] = true then "1" else "0"
Worked like a charm.
Ty very mutch for answering tho Ruksuro ;)