John Walkenbach recently posted Spreadsheet in a Phone, where he mentioned a new spreadsheet for the iPhone/iPod Touch. Well, I thought that this is the coolest thing ever, particularly as I just bought an iPod Touch (2nd generation) for my trip to the Financial Education Association meeting in Hilton Head. So, even though it isn’t free ($7.99) I headed straight to the App Store to buy a copy.
When I got there I saw that there were a few comments, and they weren’t too flattering. It seems that the Spreadsheet for the iPhone was released before it was ready for the masses (someone might think that Softalk is a division of Microsoft, but apparently that isn’t true). One small problem for some is that, at first glance, this spreadsheet can’t divide properly. One reviewer actually had the gall to complain that =3/2 returns 1 as the answer, and 2/3 returns 0. Imagine that…
Fortunately, another user helpfully pointed out that the spreadsheet can divide properly, if you know the correct formula. Apparently it understands logarithms and subtraction pretty well, so you can use this:
So, if A1 contains 3 and A2 contains 2 then we find that 3/2 = 1.50. That works in Excel 2007 as well. And my students wonder why I’m always complaining that they don’t understand how to use logarithms. Now they know.
I really want to buy this thing, but I think that I’ll wait until the next version comes out. When it does, I’ll do a review here. It really does sound worthwhile, and they are building Excel compatibility into it.
I hope that the good folks at Softalk don’t mind me having a bit of fun at their expense.
Commenting is not available in this channel entry.