Search the Community
Showing results for tags 'checking'.
Found 1 result
-
Budgets and spreadsheets go together like [...........insert your own idiom here..............] And so do errors: errors of fact and errors in formulae. Realising that, recently, every time it rains, I'm in the office trying hard to avoid checking our spreadsheet. Errors of fact Not a great lot to be done here. My only suggestion is to get a mate to check with you. @MrsRA is better at this process than I am, but we still manage to avoid the issue because it's so hard (for that read time-consuming) to do something which 'should' be easy. It isn't. Errors in Formulae Is there anything that can help the hard, detailed, mind-numbing, eye-watering, annoying slog Yes Here is a simple search for all versions of the term 'formula auditing' (because there are so many versions of spreadsheets out there) And here is one website's summary of several approaches to checking formulae in the most common (I think) spreadsheet of all. Just sayin'. Guess what I'm doing this morning.