Translations:Documentation/Calc Functions/SERIESSUM/21/en

From The Document Foundation Wiki
Jump to: navigation, search
Formula Description Returns
=SERIESSUM(7;3;5;A4:A7) where A4:A7 is 3,6,9,12,15 3*7^3+6*7^8+9*7^13+12*7^18+15*7^23 4.10550751936424E+020
=SERIESSUM(7.2;3.4;5.1;A4:A7) where A4:A7 is 3,-6,9.5,-12.7,15 3*7.2^3.4-6*7.2^8.5+9.5*7.2^13.6-12.7*7.2^18.7+15*7.2^23.8 3.8070543349058E+021
=SERIESSUM(-7;3;5;A4:A7) where A4:A7 is 3,6,9,12,15 3*(-7)^3+6*(-7)^8+9*(-7)^13+12*(-7)^18+15*(-7)^23 -4.10511670010005E+020
=SERIESSUM(-7;3.2;5;A4:A7) where A4:A7 is 3,6,9,12,15 negative number is raised to non-integer power so the function returns an error value Err:502
=SERIESSUM(0;0;5;A4:A7) where A4:A7 is 3,6,9,12,15 0 raised to the 0 so the function returns a value error #VALUE!