If you tend to put formulas in random cells around your spreadsheet, it’s time to get a bit more organized.
Having formulas all over the place makes it hard to figure out what they’re telling you. And it can take a lot of time to figure it out if you’re coming back to a spreadsheet after a long time.
Here’s a quick way to stop losing your valuable work:
In the example below, we’ll be looking up an employee’s sales on a specific date by entering their name. Without a properly formatted method of storing your formulas, you’ll just see a number the next time you come back to your spreadsheet.
And that doesn’t tell you much.
So we’re going to make it easier by making it very clear what information we’re looking up.
First, let’s make sure we know what we’re putting into the formula and what we’re getting back out. In a cell near the top of the page, we’ll type “Name,” and in the cell below it, “Date.” Below that, “Sales.”