Hi BEn,

Sir Ron, Ben can also try to use a very helpful tool in excel to derive
where the error maybe coming from the content of his formula...

toolsformula auditingEVALUATE FORMULA...

regards...
--
*****
birds of the same feather flock together..



"Ron Rosenfeld" wrote:

On Thu, 8 Feb 2007 14:06:01 -0800, Ben wrote:

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

What is clear is that what you type into the formula to replace H465 is NOT the
same as the actual contents of H465 (or the result of that formula).

Probably either a TEXT versus NUMBER issue; or possibly a rounding versus
formatting issue.

What is the formula in H465?
What are the precedents of that formula?
What is the contents of B6?




--ron