IF function - from 2 columns

[Anonymous]

Hello

Im trying to set up an IF formula in a costum column to see witch columns have True on the same row

if [NI] = "TRUE" and [DT] = "TRUE" then "1" else "0"

I dont get any errors but i just dosent do the job

[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!

[Anonymous · Accepted solution]

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 😉