LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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?




 
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
Using SERIESSUM Steve Excel Worksheet Functions 1 December 16th 04 04:57 PM
Seriessum is not quite it...need help, please lizard2806 Excel Worksheet Functions 1 November 3rd 04 02:46 PM


All times are GMT +1. The time now is 12:26 AM.

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

About Us

"It's about Microsoft Excel"