help
Use a formula. If you have a table that is 4 cells by 3 cell you have 12
cells. If you add 3 to each of the cells then the sum of the table will
increase by 3 x 12 or 36
Here is the proof
Sum((A1 + 3) + (A2 + 3) + (A3 + 3) + ... + (A100 + 3))
Sum((3 * 100) + (A1 + A2 + A3 + ... + A100))
Put in cell A1 = 3
Put in cell B1 = (A1 * Count(A1:A100)) + Sum(A1:A100)
where A1:A100 is your table. As you change A1 the data in B1 will change.
Put your refference 3 or 3.01 in cell A1.
"Fernando Duran" wrote:
I have a table, with weekly sales that I need to balance, like 3.5 for
every product to obtain a max of 26 skids for example. I need to create
a formula or a macro that will help me to balance, for example by
sliding a bar that will change equally, by adding 3 weeks or 3.01, or
3.02€¦..until I get the 26 or 27, or whatever number I need to do
|