View Single Post
  #1   Report Post  
Kat
 
Posts: n/a
Default 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))