Gwynneth Taylor
asked on
Re: Microsoft Access Formula
Hi
Can someone please help me with the following formulas to avoid
#DIV/0!
#NUM!
=[FEV1]/[PredictedFEV1]
Can someone please help me with the following formulas to avoid
#DIV/0!
#NUM!
=[FEV1]/[PredictedFEV1]
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Excellent! Fast response thank you.
some more suggestions:
=iif(a=0 or b=0, 0, a/b)
=iif(nz(a,0)=0) or nz(b,0)=0, 0, a/b)
=iif(a=0 or b=0, 0, a/b)
=iif(nz(a,0)=0) or nz(b,0)=0, 0, a/b)
=iif([PredictedFEV1]=0,0,n