I have the following if statement in one of the cells:

IF(H465=$B$6,(((($B$4)/(($D$2^$D$2)*($F$2^$F$2)))^(1/($D$2+$F$2)))),(($B$3)*((H465-$B$6)/(H465+$B$1)))))

Now it is not giving me the answer that I calculate so to troubleshoot I
started by inserting the value that is in cell H465 and it did give me the
right answer. So my question is why if I change the value of H465 to a
constant in the comparison operator does the formula work as planned but if I
leave the cell reference (H465) then it does not calculate the right value.

One more piece of information is that there is a formula in the H465 to
calculate its value. Maybe that has something to do with it? Please help!

Thanks,
Ben