E
Excel
SUM(H47:H53)/SUM(G47:G53) sometimes evaluates to #num! and sometimes
evaluates to 1.000 (as it should). If it evaluates to #num!, then if
I hit f9 enough times it may evaluate to 1.00. If I hit f9 again, it
returns to 1.000. Other cells in the spreadsheet do the same thing.
That is, when f9 causes one cell to evaluate properly, other cells go
out of whack (e.g. evaluate from 1.000 to #Num!)
1) I have a number of array formulas in the spreadsheet
2) I use logest in this spreadsheet.
3) the spreadsheet is almost 5MB as .xlsm (or almost 10MB as .xls).
Both versions have the same issue.
4) I use Excel 2007 and MS XP Pro
5) I've opened the spreadsheet using differnet computers and see the
same results.
6) I have toggeled between checking on and off the "enable iterative
calcualtions" box in "Excel options, Formulas"- yet the problem
persists.
7) I have created no user-defined functions.
Any ideas what could be wrong? Help!
evaluates to 1.000 (as it should). If it evaluates to #num!, then if
I hit f9 enough times it may evaluate to 1.00. If I hit f9 again, it
returns to 1.000. Other cells in the spreadsheet do the same thing.
That is, when f9 causes one cell to evaluate properly, other cells go
out of whack (e.g. evaluate from 1.000 to #Num!)
1) I have a number of array formulas in the spreadsheet
2) I use logest in this spreadsheet.
3) the spreadsheet is almost 5MB as .xlsm (or almost 10MB as .xls).
Both versions have the same issue.
4) I use Excel 2007 and MS XP Pro
5) I've opened the spreadsheet using differnet computers and see the
same results.
6) I have toggeled between checking on and off the "enable iterative
calcualtions" box in "Excel options, Formulas"- yet the problem
persists.
7) I have created no user-defined functions.
Any ideas what could be wrong? Help!