How is the YTD Net Budget formula calculated on the YTD Comparison Sheet. I have a formula warning on my sheet and not sure if I should be concerned. It appears to be just an inconsistent formula message ???
When I hover over the cell it states it “formula in the cell differs from the formulas in this area of the spreadsheet. It’s of those yellow triangle warning signs. Not sure if this is an issue or not. That’s why I am asking how this formula is calculated ??
thanks
I am not familiar with this sheet, however, I have see errors like this in excel, and they are typically nothing to worry about. As an example A1, A2 and A4 might be a formula to sum, and A3 is a division. Excel sees that as an inconsistent formula, even though this might be intentional. If you see the expected amounts in the highlighted section, and you haven’t been updating formulas for your own purposes, then I would say it shouldn’t be a worry.
That’s what I thought. I am still in need of understanding how the Net YTD Budget number calculated if anyone else can explain how it is generated.
Thanks
