Excel Iterarion Problem

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • =?Utf-8?B?cmFqNzQ=?=
    #1

    Excel Iterarion Problem

    I have an annoying situation when I each time open the Ms excel file I have
    to activate(pressi ng 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.

    Tags: None
    • PvdG42
      #2
      Re: Excel Iterarion Problem


      "raj74" <raj74@discussi ons.microsoft.c omwrote in message
      news:4719990D-7FFB-4144-BC2D-608C98A5C684@mi crosoft.com...
      I have an annoying situation when I each time open the Ms excel file I
      have
      to activate(pressi ng 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.
      >
      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.


        Comment

        Previous template Next
        Working...