Since you're dividing by $h$39, I would have guessed you would have used:

=if($h$39=0,"",h3/$h$39)

I don't see why F3 is part of your formula.

Micayla Bergen wrote:

i have the same formula in two cells w one small difference, and yet one
returns a DIV/0 error and the other doesnt.
D3 is this =IF(F3=0,H3/$H$39,"")
E3 is this =IF(F3=1,I3/$H$39, "")
where F3 is this =IF(ISERROR((VLOOKUP(A3,'Model Portfolio'!$A$3:$A$51,1,
FALSE))),0,1)
H3 is this =IF(AND(B3=1,F3=0),G3*C3,0)
I3 is this =IF(AND(B3=1,F3=1),G3*C3,0)
and H39 is this =SUM(H3:I38)

i cannot figure out why D3 gives the Div/0 error and E3 does not
thank you

--

Dave Peterson