Forum Discussion
Simple subtraction not calculating correctly
I think I'm losing my mind. I have a subtraction (Actuals - Planned) and it works for some months and not others. It's exactly the same formula, just for different months (hence different values)...
Thanks. Cells Q4 (January) and AA4 (February) on sheet 'Booking Fee Details 2022-2023' contained circular references. The formulas in these cells were inconsistent with the formulas in the cells below. When I copied Q5 to Q4 and AA5 to AA4, the problem disappeared.
See the attached version.
THANK YOU!!!!! I feel like my head is swimming in formulas these days. BLESS YOU