+ Reply to Thread
Results 1 to 5 of 5

do-while loop to average the sum of every seventh number

  1. #1
    Registered User
    Join Date
    10-15-2013
    Location
    united states
    MS-Off Ver
    Excel 2010
    Posts
    64

    do-while loop to average the sum of every seventh number

    Can anyone help me with this practice? I have 9 more of these to do, if someone can show me how this get done I can figure the rest of them. I need to use Visual Basic to write this.
    Thank you so much

    Use a do-while loop to average the sum of every seventh number from 3 to a final value the user enters into a texbox (3 + 10 + 17 ...). You will need a counter variable and an accumulator variable.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,599

    Re: do-while loop to average the sum of every seventh number

    Nothing is more frustrating than to be working on homework and to get stuck. Without guidance, you might have no hope of finishing the assignment before the deadline. The Internet can be a big help in that respect, but without learning how to get the right answer, asking others to solve your homework questions for you simply becomes a downward spiral (and it's cheating).

    We do not want to contribute to you cheating yourself out of your education, but we also acknowledge that seeking assistance to learn a concept is a legitimate request.

    So we would like to hear what you think how to achieve this and what you know until now and then we will gladly guide you to bring up solution for you.

  3. #3
    Registered User
    Join Date
    10-15-2013
    Location
    united states
    MS-Off Ver
    Excel 2010
    Posts
    64

    Re: do-while loop to average the sum of every seventh number

    I am not cheating, I am learning on my own, but some of these practices that I found is hard and I need some one to show me how

  4. #4
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,599

    Re: do-while loop to average the sum of every seventh number

    That's the spirit.
    Come with what you came by now and we will gladly guide you to the final solution.

  5. #5
    Registered User
    Join Date
    10-15-2013
    Location
    united states
    MS-Off Ver
    Excel 2010
    Posts
    64

    Re: do-while loop to average the sum of every seventh number

    Ok I have these codes for above problem it works but I don't get the correct average? Please advice.
    Please Login or Register  to view this content.

+ 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] add value to every seventh column
    By warden792 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-27-2015, 06:17 AM
  2. [SOLVED] Print every seventh cell in row
    By christopherL in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-22-2014, 08:22 AM
  3. [SOLVED] Formula for copying the sixth & seventh digit from a number
    By shivanikharbanda in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-25-2014, 11:22 AM
  4. [SOLVED] VBA loop to copy a worksheet a number of times, assign name each time based on loop number
    By TBG in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-29-2012, 10:54 PM
  5. SUM FORMULA- skipping every seventh row
    By bite_tony in forum Excel General
    Replies: 3
    Last Post: 08-21-2012, 11:39 AM
  6. Replies: 9
    Last Post: 05-01-2012, 11:50 AM
  7. [SOLVED] How do I delete every seventh row?
    By Caroline in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-06-2005, 12: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