If you’re like me, whenever you see “12:00 pm” or “12:00 am” you need to stop and think for a moment as to whether that’s noon, or midnight. I know I’m not the only one this happens to, since at… Read moreNoon and midnight

If you looked at the original data for the grocery price list example from a few of weeks back, you might have noticed that the original data was in a completely different format than the data in my example.

Some time back I set up an accounting spreadsheet for my local neighborhood association, and one of the things it did was keep a running balance by adding the credits and subtracting the debits for the current row to the… Read moreInserting rows or columns in incremental formulas

The example I shared last week used several different if() statements, for various purposes, and a few other formulas as well, so this week I’m going to walk you through them.

Last week I talked about how you could use if() to automatically figure out the best deal in a game, and promised a more real-life example about grocery shopping this week. To do this, I’ve made a grocery price list… Read moreFiguring out the best deal: grocery price lists