Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 12th 04, 08:55 PM
arkansooner
 
Posts: n/a
Default 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
View this thread: http://www.excelforum.com/showthread...hreadid=277849


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

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
View this thread: http://www.excelforum.com/showthread...hreadid=277849



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

Hi
post your used formula

--
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
View this thread:

http://www.excelforum.com/showthread...hreadid=277849


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

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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Circular reference Pat Excel Discussion (Misc queries) 2 January 19th 05 06:52 AM
PivotTable canned functions doco Excel Discussion (Misc queries) 0 January 14th 05 04:52 PM
Changing the language of built-in functions? Gustaf Liljegren New Users to Excel 3 December 20th 04 09:31 PM
How to load Engineering Functions into the Fx function wizard? jsaval Excel Worksheet Functions 1 November 11th 04 10:47 PM
Where can I see VBA code for financial functions? eios Excel Worksheet Functions 1 November 2nd 04 02:00 PM


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

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017