Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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)) |
#2
|
|||
|
|||
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)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
keep a running total of my formula results after each (F9) | Excel Discussion (Misc queries) | |||
Excell only displays the formula, not the results | Excel Discussion (Misc queries) | |||
I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) | |||
can i colour a cell on basis of results of a formula e.g clour bl. | Excel Worksheet Functions | |||
Formula results in font color change | Excel Worksheet Functions |