Results 1 to 7 of 7

Checking the minimum of iterative calculations:

Threaded View

  1. #5
    Registered User
    Join Date
    04-06-2016
    Location
    Trivandrum, India
    MS-Off Ver
    2010
    Posts
    4

    Re: Checking the minimum of iterative calculations:

    Thank you very much for your kind help
    The values shown in yellow highlights starting from Cell B 249 are the values obtained using a set of formulas calculated above. Each time the values are recalculated using the F9 tab, the chk fn will get updated. The values of chk fn in the cell B 249 needs to be compared with the next obtained value after recalculation and if the chk fn value is less, it should be updated in cell B264 , otherwise retain the values. The values shown in blue highlights starting from B 264 should represent the values corresponding to the chk fn. So that the lowest value for chk fn should be obtained after several recalculations in cell B264 and the corresponding values in the blue highlighted area. The problem is shown in the attached screenshot. Please help me in this regard.
    Attached Images Attached Images
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Iterative Formula
    By kathrynreno in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-29-2016, 09:23 PM
  2. Replies: 7
    Last Post: 04-17-2013, 03:53 PM
  3. Replies: 4
    Last Post: 12-10-2012, 06:22 PM
  4. Fixing a divide by 0 error with iterative calculations
    By jrm0523 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-20-2012, 02:30 PM
  5. [SOLVED] Need a formula to find the minimum value in an array, then perform calculations on ....
    By jschneider92 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-06-2012, 12:59 AM
  6. Replies: 3
    Last Post: 04-01-2012, 05:37 AM

Tags for this Thread

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