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...
Yes - =C52. C2 has a formula =SUM(C46:C51). I actually got it working though! Something was off with the C46-C51 data. Once I fixed that, my C21 issue went away. Weird thanks for the reply though.
My guess is that one of the formulas caused a circular reference (a formula that directly or indirectly refers to the cell containing the formula). That would prevent Excel from recalculating correctly.