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,

1 Reply

  • 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,