View Single Post
  #4   Report Post  
Thermal manager
 
Posts: n/a
Default

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?