+ Reply to Thread
Results 1 to 3 of 3

Increment a cell value until it satisfies a criteria and stop and retain the minimum value

  1. #1
    Registered User
    Join Date
    12-27-2011
    Location
    India
    MS-Off Ver
    365 subscription
    Posts
    6

    Increment a cell value until it satisfies a criteria and stop and retain the minimum value

    1 2 0.01 Fail
    2 3 0.01 Fail
    3 4 0.01 Fail
    4 5 0.01 Fail
    5 6 0.01 Fail
    6 7 0.01 Fail
    7 8 0.01 Fail
    8 9 0.01 Fail
    9 10 0.01 Fail
    10 11 0.01 Fail
    11 12 0.01 Fail
    12 13 0.01 Fail

    increments should be in 0.01 only and once it reaches 1.01 the loop should end and C value should remain 1.01,
    suggest me a function.

    Thanks in advance.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,986

    Re: Increment a cell value until it satisfies a criteria and stop and retain the minimum v

    What is incrementing by 0.01 and what is in column C? Can you possibly post an Excel sheet, rather than this, as I can't really see what is in which column?
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    12-27-2011
    Location
    India
    MS-Off Ver
    365 subscription
    Posts
    6

    Re: Increment a cell value until it satisfies a criteria and stop and retain the minimum v

    thanks for quick response, pl find the attachment
    Attached Files Attached Files

+ 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. [SOLVED] Find minimum (ignoring blank cell or zero values) with Multiple Criteria
    By Joeywei in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 05-27-2013, 08:45 PM
  2. Identify quantity of unique data that satisfies a particular criteria
    By petermichael in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 01-07-2013, 09:31 AM
  3. How to stop excel to increment horizontal
    By amb1s1 in forum Excel General
    Replies: 1
    Last Post: 08-13-2012, 01:26 PM
  4. Minimum values based on criteria in another cell
    By ekm in forum Excel General
    Replies: 6
    Last Post: 07-16-2010, 02:33 PM
  5. stop automatic increment of dates
    By Susan C. in forum Excel General
    Replies: 2
    Last Post: 09-21-2005, 01:05 PM

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