Forum Discussion
Why all the zeros and brackets?
Hello, I have inherited a budget forecasting spreadsheet at work and the last row calculates net profit by taking net overhead (in this case cell H118) away from net income (H13) for any given month...
Thank you very much mathetes
Unfortunately I can't post the spreadsheet as it contains all our financial information.
I will do as you say and revert to the simple formula.
It would be great to know though if all those zeros and brackets serve any purpose at all.
Thanks again.
It would be great to know though if all those zeros and brackets serve any purpose at all.
My guess is that there were at one time other cell references that were in there--subtotals of certain categories, perhaps--and whoever was "managing" the spreadsheet at the time wanted to keep a record sort of as placeholders....but there is no reason to keep them. Adding or subtracting zero, with our without the brackets, has, well, zero effect.