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)...
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
HansVogelaar Sorry for the delay. Thank you for your response. I have created this https://1drv.ms/x/s!AorMZStdJCLogXcpR4gPmdZcks0R?e=8ClCM8 for you to see. Let me know if you have any trouble accessing it.
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
