From The Document Foundation Wiki
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!
|