+ Reply to Thread
Results 1 to 3 of 3

Do While within a range

  1. #1
    Registered User
    Join Date
    01-28-2010
    Location
    Akron, OH
    MS-Off Ver
    Excel 2007
    Posts
    11

    Do While within a range

    I've been trying to figure this out for a while now...

    I have a do while loop
    on the first itteration the result will be 70
    on the 2nd it will be 82
    on the 3rd it will be 92
    on the 4th it will be 103

    I need it to stop when it gets above 90 and below 100
    ie:
    if on the 3rd its 92, 4th 99, 5th 102 i need it to stop on the 4th

    I hope this makes sense.

    Do While 90 < flowtest2 < 100
    doesnt work :D (thats what I want.)

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Do While within a range

    Why don't you post your code so we can take a look. Loops are inefficient and someone may suggest a more efficient approach.

    Maybe . . .
    Please Login or Register  to view this content.
    Palmetto

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Do While within a range

    Maybe ...
    Please Login or Register  to view this content.
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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