ISERROR Question

H

hrskinn

My Formula

Y_N: IIf(IsError(([MAINTINV_RTL]-[MAINTINV_CST])/[MAINTINV_RTL]),"Y","N")

I either get #Error or N

Thanks
 
J

Jason Lepack

I assume you're just trying to catch a divide by zero error.

Y_N: IIf([MAINTINV_RTL]>0,"Y","N")
 
Top