Forum Discussion
Weird Excel Issue - 0 showing up instead of correct value
Hi, so I've been using excel for a long time and never ran into an issue like this. I have 5 cells. 4 of them show a currency value: C18 - $10,062.25 C19 - $7,435.63 C20 - $2,501.70 C21 - $16,09...
Solved the same issue,
The issue was that one of the numbers I was trying to calculate was result of cyclic formula, which returned 0, making any following function including that cell return 0. It also affected logic functions like isnumber() returning always 0.