Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to make a sum from i=0,....,K
Hello to everybody! I woul like to know how to make a sum of this function (1+L)exp(n)/(n-L)! from n=1,...,k. The values of K and L can is the user the one who has to input them. Thanks a lot in advance Carlos -- carlosgdlf ------------------------------------------------------------------------ carlosgdlf's Profile: http://www.excelforum.com/member.php...o&userid=25821 View this thread: http://www.excelforum.com/showthread...hreadid=478810 |
#2
|
|||
|
|||
How to make a sum from i=0,....,K
Carlos,
the problem does not appear very well defined. If L is greater than 1, say 4, then (n-4)! is not defined for n=1, 2, 3, because it is negative. At any rate, you can approach this problem by breaking it to columns. $G$1 holds L. One helper column (say A:A, starting from A1) should have the numbers 1, 2, ... The next one should have the numerator =(1+$G$1)*exp(A1) The third column should contain the factorial. A quick way to do this is with an array formula =PRODUCT(ROW(INDIRECT("1:" & V), where V is the expression that holds your number. In this case V would be A1-$G$1. As you can see this last one will product negative values and #REF! in the cell. Continuing, the next column would be =B1/C1 Finally, the last column would be =SUM($D$1:D1) and copied. At each row you have the result for the corresponding K. I suspect this is not quite what you need, maybe other contributors can help, as surely will your clarification on the problematic factorial. HTH Kostis Vezerides |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shuffling Data To Make Lists Match | Excel Worksheet Functions | |||
How to make empty cells as zero in excel add-ins for SQL Server an | Excel Worksheet Functions | |||
make hidden window or workbook visible without specify the name | Excel Worksheet Functions | |||
make cell contents equal to null value - not blank, but empty | Excel Worksheet Functions | |||
How do I make an If-Then formula in Excel? | Excel Worksheet Functions |