LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default Creating A sumation formula

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Vlookup multiple lookup values and sumation Matt Excel Worksheet Functions 3 August 14th 08 03:53 PM
shaded cell sumation oldLearner57 Excel Discussion (Misc queries) 2 April 23rd 08 09:52 PM
Error handling VLOOKUP. #N/A - can it be 0 to allow sumation. Richhall Excel Worksheet Functions 3 October 8th 07 12:31 PM
Sumation Bikertyke Excel Discussion (Misc queries) 4 February 6th 07 08:07 AM
How am i able to populate a sumation for multiple sheets swiftcode Excel Worksheet Functions 2 September 29th 05 02:33 AM


All times are GMT +1. The time now is 11:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"