Formula result other than displayed

[Robin121]

Hello people,
The formula I've written shows a zero as result, whereas when clicking the fx-symbol to check the formula, it shows the result will be 1; as expected. Who can tell me why I see a '0' as result in the cell?

 

[jasonb75]

Could be one of many reasons, can't say which without seeing the formula, probably going to need sample data to compare as well.

 

[Fluff]

Do you have any circular references?

 

[Robin121]

Do you have any circular references?

...blinded by the light.....
yeah I do; I'll look into that, thanks

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Robin121]

Hello again. This previous post was part of my attempt to write a sudoku-solver using excel iterative calculations. Is that possible, at all?? So far I wrote in-cell 'modules' for the different common solve-tactics, but I realize I can't influence the sequence in which the modules need to be applied? Anyone got experience / tips / reading material? Thanks!