The choose() function

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 maximum number of options, of course! You could in theory have just =choose(IndexNumber,option1), though there wouldn’t be much point. Continue reading The choose() function

Simple statistics: counting blank results

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 gone I’ll be posting a few things that I started some time back, but which somehow never got posted.

The first of these is a post I wrote back in June 2012 when I was talking about counting blanks and counting entries. Continue reading Simple statistics: counting blank results

Using concatenate() to write HTML code (presenting data online)

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 online world. You can save a chart or graph as a picture and post it online, but if you try to do that with a table it will be much less helpful than actually having the numbers online where they can be copied.

There are a couple of ways to easily post the numbers online, and which one is best depends on whether you expect to be updating it regularly, and the accessibility of scripting languages such as PHP. They’re both pretty involved, though, so I’ll talk about one this week, and the other one in another post. Continue reading Using concatenate() to write HTML code (presenting data online)