| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Code for sigma of product involving exponential - help
Hi Ron,
Am Wed, 25 Apr 2018 09:58:09 -0700 (PDT) schrieb Ron George: f(n) = k1 x Sigma [w(i) x exp(-n-i)/tau1] where i goes from 1 to n-1. your formula: =$B$4*SUMPRODUCT(D2*EXP(-1*(ROW(INDIRECT($A$2&":"&C2-1)))/$B$3)) ^^^^^^ C2 = 1 and C2-1 = 0 That causes the error. Try: =$B$4*SUMPRODUCT(D2*EXP(-1*(ROW(INDIRECT($A$2&":"&C2)))/$B$3)) Regards Claus B. -- Windows10 Office 2016 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Product Code | Setting up and Configuration of Excel | |||
| Product Code and Product Description setup | Excel Worksheet Functions | |||
| Vlookup code product and to copy commentary with photo of the product in vba | Excel Programming | |||
| ROBBYN - RE -Code Refinement involving blank cell(s) COULD NOT POST FOLLOWUP | Excel Programming | |||
| Code Refinement involving blank cell(s) | Excel Programming | |||
Threaded Mode
