Help! Getting different results for the same formula.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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(C19>0,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(C19>0,C19-SUM(F19:K19,L18)+SUM(F18:K18),IF($E19=$L$2,$L18-$D19,L18)
)
 
Back
Top