Forum Discussion

aishak12's avatar
aishak12
Icon for Helper IV rankHelper IV
5 years ago
Solved

IF statement for negative number to equal 0

Hi All, Im looking to create an IF statement that if the value returns a negative number to replace it with 0. I can't filter out the negative numbers since I need there values in other coloumn...
  • amitchandak's avatar
    5 years ago

    aishak12 , Not very clear

    A new column

    if([OT Hours] <0 ,0, [OT hours])