Link to home
Start Free TrialLog in
Avatar of Kim Williamson
Kim WilliamsonFlag for United States of America

asked on

Divide by zero error

I have a formula that on certain items will cause a divide by zero error.  I need to figure out how to get past this and not calculate the formula if there is a zero.

({XFGMULTI.NEW_QUAN} / {@perpetual}) * 100
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Kim Williamson

ASKER

The first example was exactly what I needed.  Thanks!