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?