Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Sort of a school project, basically I need to sum the following equation:
k goes from 0 to 100 ( A^( k+1 ) ) * ( B / C ) * ( 1 - ( D / E ) ) where A, B, C, D, E are all cell references that increase by k each time for the sumation, but there is no way to find a funtion, so I think I have to make a loop in VBA, but I don't really know how to use my reference cells. Ultimately I would like to call a function like this: =Sum3up( array1, array2, array3, integer ) where the 3 arrays are my colums or rows, and my integer is the value of k. Not much of a program but if I get pointed in the right way I can figure most things out, once I get a nudge. Clinton |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Vlookup multiple lookup values and sumation | Excel Worksheet Functions | |||
shaded cell sumation | Excel Discussion (Misc queries) | |||
Error handling VLOOKUP. #N/A - can it be 0 to allow sumation. | Excel Worksheet Functions | |||
Sumation | Excel Discussion (Misc queries) | |||
How am i able to populate a sumation for multiple sheets | Excel Worksheet Functions |