Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
carlosgdlf
 
Posts: n/a
Default 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   Report Post  
vezerid
 
Posts: n/a
Default 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
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
Shuffling Data To Make Lists Match Dmorri254 Excel Worksheet Functions 1 January 14th 05 06:58 PM
How to make empty cells as zero in excel add-ins for SQL Server an Microlong Excel Worksheet Functions 0 January 12th 05 07:31 AM
make hidden window or workbook visible without specify the name mango Excel Worksheet Functions 1 December 30th 04 04:05 PM
make cell contents equal to null value - not blank, but empty mpierre Excel Worksheet Functions 1 December 29th 04 07:57 AM
How do I make an If-Then formula in Excel? kdub1980 Excel Worksheet Functions 3 November 11th 04 07:08 AM


All times are GMT +1. The time now is 11:02 PM.

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

About Us

"It's about Microsoft Excel"