[geeks] Excel

[Joshua D Boyd]

Anyone care to comment on modularize excel development, specifically of
complex formulas in cells (as opposed to writing macros)?

I find myself writing formulas like this '=IF(AND(Vars!$B$35=TRUE,
and(not(Vars!$B$17="I4"),and(not(Vars!$B$17="I6"),not(Vars!$B$17="I10")))),
"Indented", "")' in cells, and wish there was a way to simplify them to
make them more readable, maintainable, and debugable.  The whole thing
is somewhat embarassing, but nescesarry for now.  I wish the whole thing
would be redone in say in Java, C++, smalltalk, whatever windows
platform you pick, but even if I redid it for free in my own time, it
wouldn't be accepted for reasons of too much momentum behind excel.

-- 
Joshua D. Boyd