Help! Getting different results for the same formula.
 

I am using a complex If function. Whenlooking at the detailed view of the IF
function it gives me the correct answer. However when I press enter 0 showes
up in the cell. Anyone know what is going on?
Function is:
IF(C190,C19-((F19-F18)+(G19-G18)+(H19-H18)+(I19-I18)+(J19-J18)+(K19-K18))+L18,IF($E19=$L$2,$L18-$D19,L18))

Hi
one idea: a circular reference?

Also I would change the formula to
=IF(C190,C19-SUM(F19:K19,L18)+SUM(F18:K18),IF($E19=$L$2,$L18-$D19,L18)
)

--
Regards
Frank Kabel
Frankfurt, Germany

"Kat" schrieb im Newsbeitrag
...
I am using a complex If function. Whenlooking at the detailed view of
the IF
function it gives me the correct answer. However when I press enter 0
showes
up in the cell. Anyone know what is going on?
Function is:

IF(C190,C19-((F19-F18)+(G19-G18)+(H19-H18)+(I19-I18)+(J19-J18)+(K19-K1
8))+L18,IF($E19=$L$2,$L18-$D19,L18))