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
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
Maybe...
=ROUNDUP(A3/10,0)
With your sample, I would say the answer is one?
HTH
Regards, Jeff
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.
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
Originally Posted by shg
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?
Appreciate it MrShorty thanks from taking the time to assist me. I can finish this now,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks