Forum Discussion

Beyondforce's avatar
Beyondforce
Icon for Helper I rankHelper I
9 years ago
Solved

Adding a new column but the IF formula doesn't work!

Hey Guys,   I'm trying to add a new column and I'm also adding this formula, but it's not working! What's wrong with it? =IF([LateStart]= 0, && ([LateEnd] = 0),0))   Thanks. Ben.
  • ibarrau's avatar
    ibarrau
    9 years ago

    Hello, the sintaxis is incorrect

     

    =IF('TableName'[LateStart]= 0 && 'TableName'[LateEnd] = 0, 0)
    Or you can consider using AND function

    =IF( AND('TableName'[LateStart]= 0 , 'TableName'[LateEnd] = 0), 0)

     

    Remember I copy your example. You should put an else statement.

     

    Regards,

ibarrau's avatar
ibarrau
Icon for Super User rankSuper User
9 years ago

Hello, the sintaxis is incorrect

 

=IF('TableName'[LateStart]= 0 && 'TableName'[LateEnd] = 0, 0)
Or you can consider using AND function

=IF( AND('TableName'[LateStart]= 0 , 'TableName'[LateEnd] = 0), 0)

 

Remember I copy your example. You should put an else statement.

 

Regards,