Forum Discussion

JohnRomano's avatar
Qrew Trainee
17 days ago

Division Formula error

What is the best way to handle a division formula that is dividing by zero and returns an error? I would like the error to return a Zero.

1 Reply

  • Np,

    var text Numerator = insert formula here;

    var text Denominator = insert formula here;

    IF($Denominator=0, 0, $Numerator / $Denominator)