Link to home
Create AccountLog 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
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Kim Williamson

ASKER

The first example was exactly what I needed.  Thanks!