Question

Division Formula error

+5

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.

This topic has been closed for replies.

+24

Np,

var text Numerator = insert formula here;

var text Denominator = insert formula here;

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

Mark Shnier. Your Quickbase Coach

Sign up