News for hackers. Stuff that matters.
Re:Damn Excel – How the 'most important application' is ruin... by andreasvc on Saturday April 20, 2013 @09:32PM (#5583505)
Naming a single cell doesn't solve the problem of accidentally using a different range of values. In a normal programming language you would define a variable such as GDP containing a list of values for the countries of interest, in Excel every formula has to restate the range, which is what caused the mistake.
Re:Damn Excel – How the 'most important application' is ruin... by LyndsySimon on Sunday April 21, 2013 @01:52AM (#5584020)
That's not the case.

You can have named ranges in Excel - in fact, you can have named ranges which are dynamically calculated based on a formula.