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
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 only show each year once in a list of dates was =if(month(Date)=1,concatenate(” “,year(Date)),””). However, it might be easier to read as this: Continue reading If() 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 the different types of codes where they needed to be. However, I could have used if() to make my life easier in a couple of ways. Continue reading Using 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 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
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)