Home |
Search |
Today's Posts |
#4
![]() |
|||
|
|||
![]()
Well, I really think this is an error Microsoft should solve, the coder of
this function should be ashamed of such an error. In the mean time I improved the function below to: =IF(X= 0, a0, SERIESSUM(X,n,m,a0:ai)) as this avoids calculating the seriessum twice. "Bernie Deitrick" wrote: Thermal, 0 raised to any power is still 0, so you could simply use =IF(ISERROR(SERIESSUM(X,n,m,Coefficients)),0,SERIE SSUM(X,n,m,Coefficients)) HTH, Bernie MS Excel MVP "Thermal manager" <Thermal wrote in message ... The function SERIESSUM(X,n,m,Coefficients) gives an error for X=0 How to solve it, the function is useless as it is? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using SERIESSUM | Excel Worksheet Functions | |||
Seriessum is not quite it...need help, please | Excel Worksheet Functions |