Excel Iterarion Problem

  • Thread starter Thread starter raj74
  • Start date Start date
R

raj74

I have an annoying situation when I each time open the Ms excel file I have
to activate(pressing F2) a output cell (Col C) which is having a circular
reference with Col A and enterthe cell to get the desired value which is lost
when i reopen it nextime and show #value.
The ouput cell C is having a interpolate function (macro) to interpolate
from a range of value given separately for the value of corresponding B cell.
How to remove these bug, any macro help.

The File:

The three data range

A1 B1 C1
A2 B2 C2
A3 B3 C3

Now the three cols are linked by following relation

A = 4 + C
B = constvalue x A, Here B1 = 1.0 * A1, B2 = 0.9 * A2, B3 = 0.98 * A3
C = Function of (B)

C value is retrived by interpolation between a range of B & C, Given
separately, For that a macro has been writeen.


Regards

Raj

PS : Approximate 10-15 iteration it takes before converging.
Could I attach the .xls file.
 
raj74 said:
I have an annoying situation when I each time open the Ms excel file I
have
to activate(pressing F2) a output cell (Col C) which is having a
circular
reference with Col A and enterthe cell to get the desired value which is
lost
when i reopen it nextime and show #value.
The ouput cell C is having a interpolate function (macro) to interpolate
from a range of value given separately for the value of corresponding B
cell.
How to remove these bug, any macro help.

The File:

The three data range

A1 B1 C1
A2 B2 C2
A3 B3 C3

Now the three cols are linked by following relation

A = 4 + C
B = constvalue x A, Here B1 = 1.0 * A1, B2 = 0.9 * A2, B3 = 0.98 * A3
C = Function of (B)

C value is retrived by interpolation between a range of B & C, Given
separately, For that a macro has been writeen.


Regards

Raj

PS : Approximate 10-15 iteration it takes before converging.
Could I attach the .xls file.
Click to expand...

You need to find an Excel group for your question. This is a .NET
programming group.

As you appear to be using a web interface, start here to find an appropriate
group:

http://www.microsoft.com/communities/newsgroups/en-us/default.aspx

Click the + beside your language. then scroll down to Office and Desktop
Applications. In Office and Desktop Applications,
open the Excel category, then find a group there to post in.
 
Back
Top