Remember Me?

#1
November 12th 04, 08:55 PM
 arkansooner Posts: n/a
Circular functions

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

Does anyone know how to solve this type of functions?

--
arkansooner
------------------------------------------------------------------------
arkansooner's Profile: http://www.excelforum.com/member.php...o&userid=16417

#2
November 12th 04, 09:18 PM
 Niek Otten Posts: n/a

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

"arkansooner" wrote in message
...

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

Does anyone know how to solve this type of functions?

--
arkansooner
------------------------------------------------------------------------
arkansooner's Profile:
http://www.excelforum.com/member.php...o&userid=16417

#3
November 12th 04, 09:53 PM
 Frank Kabel Posts: n/a

Hi

--
Regards
Frank Kabel
Frankfurt, Germany

"arkansooner" schrieb im
Newsbeitrag ...

I'm attempting to solve a function, but this function id dependent on
itself. Everytime I attempt to solve, excel tells me that I'm

solving
a circular function. When I attempt to iterate the function, I get
div/0 in the cell.

Does anyone know how to solve this type of functions?

--
arkansooner
---------------------------------------------------------------------

---
arkansooner's Profile:

http://www.excelforum.com/member.php...o&userid=16417

#4
November 12th 04, 10:01 PM
 JE McGimpsey Posts: n/a

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

In article ,
arkansooner wrote:

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

Does anyone know how to solve this type of functions?

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Pat Excel Discussion (Misc queries) 2 January 19th 05 06:52 AM doco Excel Discussion (Misc queries) 0 January 14th 05 04:52 PM Gustaf Liljegren New Users to Excel 3 December 20th 04 09:31 PM jsaval Excel Worksheet Functions 1 November 11th 04 10:47 PM eios Excel Worksheet Functions 1 November 2nd 04 02:00 PM

All times are GMT +1. The time now is 06:47 AM.