I have a excel sheet that has only four rows of numbers and a fith row that is the average, no big deal. see below

before solver
54
53
21
62
Average = 47.5
after solver
76.5
75.5
43.5
84.5
Average = 70.0

Now i have the solver doing a calculation that i have the average to be 70 and it will adjust the top four rows to total a 70 in the average. how can i do this in vb without solver, is there a calcualtion?

Forgot to mention this is a vb6 project i'm doing

Well, to find the average of any group of numbers it is the sum of numbers divided by the number of elements.

Good Luck

Well, to find the average of any group of numbers it is the sum of numbers divided by the number of elements.

Good Luck

But he needs to read the number from excel sheet :D .

I know how to get the average... But i need the average to be a specific number such as 70.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.