Forum Discussion

xDaniellaM's avatar
xDaniellaM
Regular Visitor
3 years ago
Solved

Writing an If and AND Statement

Hi all,

 

I need to write an IF and AND statement to check the values of a column called Discount. I need the statement to check that all values in the column are >0 and <=1.

 

Thanks.

Need Help
  • Ritaf1983's avatar
    Ritaf1983
    3 years ago

    Hi xDaniellaM 

    If I understand correctly and you want to add the calculated column, the formula is :

    flag = if('your table[Discount] >0 && 'your table[Discount] <=1,"yes","no")

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

1 Reply

  • Ritaf1983's avatar
    Ritaf1983
    Icon for Super User rankSuper User
    3 years ago

    Hi xDaniellaM 

    If I understand correctly and you want to add the calculated column, the formula is :

    flag = if('your table[Discount] >0 && 'your table[Discount] <=1,"yes","no")

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly