It evaluates every value within the OR function before returning a value, so
if A1=0 B1/A1 will return #DIV/0! Try doing it this way:

=IF(OR(B1=0,A1=0,),0,IF(B1/A1=99.5%,0,B1/A1))
--
Regards,
Dave


"Mandy" wrote:

I have created a formula IF(OR(B1=0,A1=0,B1/A1=99.5%),0,B1/A1). If the
value of B1=0, the formula seems to ignore the first 2 criteria and focuses
on the 3rd logical portion. I don't understand this since the OR function
should return "TRUE" if any of the conditions are met, which in this case is
met on the 1st one. Why is this? Note if you remove the 3rd logical
scenario of B1/A1 the formula works, so I know without a doubt this is where
the problem is, I just can't figure out why or how to get around it.
--
Thank you