Re:Light Table - a new IDE concept
by snprbob86 on Friday April 13, 2012 @01:56PM
(#3837955)
> There's the fact that you're dealing with cell references rather than variable names, so all of your expressions look like ($K4 - $S$1) rather than (principal - payment).
In Excel, use the "Name Manager" dialog and the "Name Box" on the formula bar. They re somewhat hidden, but discovery of them forever changed my spreadsheets!
Re:Light Table - a new IDE concept
by moomin on Friday April 13, 2012 @04:38PM
(#3838735)
Even better, stick the name at the end of the row or column, select the entire range and press alt-i n c. Good luck discovering that since they introduced the ribbon bar, though.
In Excel, use the "Name Manager" dialog and the "Name Box" on the formula bar. They re somewhat hidden, but discovery of them forever changed my spreadsheets!