Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|