Prevent broken formulas using tables, validation rules, separate worksheets, named variables, and the power of LAMBDA.

Hiya. I use OO Calc on XP mostly, but since they're pretty interchangeable I figure excel answers will work just as well. <BR><BR>I have been making spreadsheets for doing statistical methods (eg, ...