I have a simple formula that is displaying correctly in every cell above and below one problem cell. It is showing as blank (and if you try to do a sum, it is truly blank), but the function argument displays the result as 3,313.
- Auto-calculations are on.
- If I add this cell to a cell that's equal to 10, the result is 10
- The formula is:
=IF(SUM(X25:X106<1),"",X25)
I suspect the issue is not with the formula, as it works everywhere else.
