Recently I mentioned the choose() statement. The syntax is =choose(IndexNumber,option1, option2, option3, … , optionLast) Open Office and Google Docs can have up to 30 options, and Excel 2010 can have up to 254. You’re not required to have the… Read moreThe choose() function

If you’re having trouble reading an if() function as it’s written in the cell, or if you’re just having trouble remembering which part is which, you can always use the wizard to help. For example, the formula I used to… Read moreIf() help wizard

In the process I talked about last week, there were a lot of different styles that the cells could have, and there were a few different situations the cells could be in. In the example I posted, I manually put… Read moreUsing if() to made varied concatenate() formulas easier

When this posts I’ll be on my way to a week long conference, and while I knew this conference was coming I always forget how much time it takes beforehand to prepare, and afterwards to catch up. So while I’m… Read moreSimple statistics: counting blank results

A couple of weeks ago I talked about the options for preparing data for presentation using the tools available in most spreadsheets, but that’s great for using in a word processor or a slide presentation, but we live in an… Read moreUsing concatenate() to write HTML code (presenting data online)