I am building a forestry growth and harvest model that forecasts out twenty
years ahead. I need to be able to change assumptions such as beginning
volume per acre and annual harvest volume. I have a circular reference and
have turned on iteration to allow recalculation. However, I get "Divides by
Zero Error" (#DIV/0!) beginning a year ten when I change an assumption.
Changing the number of maximum iterations and maximum change does not appear
to ahve any impact. If I recopy the formula over the error message, #DIV/0!,
when the cells recalculate with a value. What options do I have to change
assumptions without errors?
--
rocknroll