Help! Getting different results for the same formula.

K

Kat

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))
 
F

Frank Kabel

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)
)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula Help 2
Formula 4
non-VBA Alternative to SUBTITUTE function 6
Help ! How do I do this in VB Script 3
Run Time Error 7
Projected Charges 4
Run-time error 1004 Method "Range of object_global failed 5
Tab - Back Tab Question 2

Top