Forum Discussion

Anonymous

Not applicable

9 years ago

Solved

IF function - from 2 columns

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

Anonymous
9 years ago
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 ;)

2 Replies

Ruksuro
Helper III
9 years ago
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
  Not applicable
  9 years ago
  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 ;)