Re:Ask HN: What can't you do in Excel?
by dmoney on Sunday January 11, 2009 @07:13PM
(#429866)
Recursion is fun, but how would you use it in a spreadsheet?
[ Parent
| on HN ]
Changing values in place?
A1 = 0.1*A1
Can be useful if you need to convert values, etc., but don't want to create an entire new row/column
Can't think of a concrete example at the moment, but there have been cases when I had to make a financial model with a lot of columns (and rows) where a recursive algorithm would have presented the result I was looking for using a lot less cells.