+ Reply to Thread
Results 1 to 2 of 2

iterate

  1. #1
    Registered User
    Join Date
    05-29-2014
    Posts
    20

    iterate

    dear all,

    i want to iterate in excel
    in worksheet1
    like i have cordinates (x,y) whose range is (0,0) to (100,100)
    now i have two variables a=(2(x) +B10 + C10)
    b= ( 3(y) + B10+ C18) {B10 ,C18,C10,D12 are from worksheet 2(main working program sheet}

    now i want to iterate for x,y to get (a/b)=D12 and than want to return the values of x,y to working sheet 2

    (x,y) can be like (1,3) (1,100) (2,5) (100,3)

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,810

    Re: iterate

    I'm not quite understanding the problem. It sounds like a "solve a system of equations" kind of problem, but I can't be sure of what is given and what our your unkowns are. It sounds like you are given B10, C10, C18, and D12; and you need to solve for x and y.

    It is also not clear to me, when you say you want to "iterate" exactly what algorithm you are trying to use. Are you allowed to use Solver for this problem? Solver is usually how we implement numerical algorithms in Excel, and I expect it would make short work of this problem. If you are not allowed to use Solver, it might help if we knew what you were supposed to learning, or what skill this exercise was supposed to demonstrate.

    I find that these kind of problems often need to be handled outside of Excel until the problem is in a form that we can understand how to program it. This may mean algebraically manipulating it into a "root finding" problem. Or rearranging until you have equations where y=f(x) and x=g(y). We can then make an educated guess for one of them, then use successive approximations until it converges on a solution. Or whatever makes sense for this problem.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Using For Each to iterate each cell in a row
    By 6StringJazzer in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-02-2011, 12:19 PM
  2. need to iterate, or something...
    By jacquesmckenna in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-28-2008, 11:34 AM
  3. Iterate through a form
    By RobEdgeler in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-17-2005, 01:58 PM
  4. Iterate through controls
    By lgbjr in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-28-2005, 10:05 AM
  5. Can't iterate thru a row with For
    By peter in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-07-2005, 01:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1