+ Reply to Thread
Results 1 to 6 of 6

Finding how may 10s needed to reach the target

  1. #1
    Registered User
    Join Date
    07-24-2017
    Location
    xxxx
    MS-Off Ver
    2007
    Posts
    13

    Finding how may 10s needed to reach the target

    Hello Excel Masters,

    Need your help in creating a Macro or formula in finding the total # of 10s needed to reach the target kind see attached screenshot
    Sample.PNG

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Finding how may 10s needed to reach the target

    Maybe...

    =ROUNDUP(A3/10,0)

    With your sample, I would say the answer is one?
    HTH
    Regards, Jeff

  3. #3
    Registered User
    Join Date
    07-24-2017
    Location
    xxxx
    MS-Off Ver
    2007
    Posts
    13

    Re: Finding how may 10s needed to reach the target

    thanks for the response Jeff. But what i need is how many 10s I need to add in column E to get the average on column B3 to match what is indicated in Column A3.

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

    Re: Finding how may 10s needed to reach the target

    I would first make it an algebra problem, then it should be a relatively simple programming problem.

    current average=sum(E)/count(E).
    new average = (sum(E)+n*10)/(count(E)+n) solve for n. Put that formula into C3.

    At this point I will assume your algebra skills are sufficient to solve this problem. If you need a quick refresher: http://www.purplemath.com/modules/solvelin3.htm
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

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

    Re: Finding how may 10s needed to reach the target

    The solution to "sucking at algebra" (from your PM) is to study and practice. Did you review the purplemath tutorial? I linked you into the middle of the lesson about multi-step equations. If you have trouble with the multi-step, it would probably be valuable to back up to the single step part of the tutorial.

    new average=(sum(E)+n*10)/(count(E)+n) -> first step is to get rid of the division. "Undo" division by multiplying both sides by (count(E)+n)
    new average*(count(E)+n)=sum(E)+n*10 -> get rid of parentheses on left side using distributive property a*(b+c)=ab+ac
    new average*count(E)+new average*n=sum(E)+n*10 -> At this point, it should look a lot like many of the examples in the tutorial. move all terms with n to the same side and terms without n to the other side
    new average*n-10*n=sum(E)-new average*count(E).

    That should be a good start. Can you finish it?

  6. #6
    Registered User
    Join Date
    07-24-2017
    Location
    xxxx
    MS-Off Ver
    2007
    Posts
    13

    Re: Finding how may 10s needed to reach the target

    Appreciate it MrShorty thanks from taking the time to assist me. I can finish this now,

+ 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. Calculating how many 100s are needed to reach target goal
    By shadowfax1416 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-28-2017, 11:23 PM
  2. [SOLVED] Number of Months to Reach Target
    By swong1709 in forum Excel General
    Replies: 5
    Last Post: 06-12-2017, 11:59 AM
  3. [SOLVED] Looking for a way to calculate items needed to reach target %
    By UNCDave13 in forum Excel General
    Replies: 13
    Last Post: 01-24-2017, 02:05 AM
  4. Formula to calculate daily sales needed to reach a specific target
    By smsmworld in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 12-17-2016, 03:27 PM
  5. [SOLVED] Count Columns until reach target
    By alexpickup in forum Excel General
    Replies: 3
    Last Post: 01-05-2015, 12:28 PM
  6. Finding a Daily Average needed to reach a Monthly goal
    By photoant in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-02-2014, 09:19 PM
  7. Replies: 1
    Last Post: 07-29-2010, 12:22 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