Circular functions

[arkansooner]

I'm attempting to solve a function, but this function id dependent o
itself. Everytime I attempt to solve, excel tells me that I'm solvin
a circular function. When I attempt to iterate the function, I ge
div/0 in the cell.

Does anyone know how to solve this type of functions

 

[Niek Otten]

You'll have to be a bit more specific on what formulas/functions you're
trying to solve. Include details about values of input cells, results you
expect, etc.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Frank Kabel]

Hi
post your used formula

 

[JE McGimpsey]

You don't give enough information about your function to hazard a guess,
but you can see the mechanics of setting up an intentional circular
reference at

http://www.mcgimpsey.com/excel/accumulator.html