Iterations reurning a #Div/0

Hello

I have a formula that has iterations, that repeats itself over 40 years. Given that the previous year affects the subsequant years, eventually my formula returns a #DIV/0 answer.

I have increased the iterations to 32000 and the accuracy down to 0.1. To rectify the issue, I must delete the circular reference cell and then copy it back in, in which case I get the answer as required.

Is there a way to rectify this issue?

Thank you
Trilogy

Hello Trilogy,

To get an answer to your question, you should post your code.

Sincerely,
Leith Ross

you can add an "iserror" clause to ur formula

Given I am new to this forum and such, in order to post the code, do I attache my spreadsheet to this thread?

Also, what is is an 'iserror'

Sincerely
Trilogy

You can attach your spreadsheet. First, compress the file into a .zip format. Then, attach it to your reply.

An "iserror" clause in a function just tells the function to do something different if the result is an error (in this case the #DIV/0 error)

Hello

Here is my code, any assistance would be very much appreciated

Apologies on the delay, have been very busy at this time

Thank you

Trilogy