| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
making a sum of a eq. with a var running form 0-infinity.
How do I make a sum of the result from a eq. with a var (n) running from 0 -
infinity? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
making a sum of a eq. with a var running form 0-infinity.
You are in luck:
Because of Excel's use of the IEEE standard for number representation, any convergent infinite series can be exactly represented in Excel by a finite set of terms (any additional terms being so small that they do not change the result). Put the set of partial sums in a column and stop when the sum stops changing. -- Gary's Student "silverspace" wrote: How do I make a sum of the result from a eq. with a var (n) running from 0 - infinity? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Baffling! Spreadsheet Data Form Size | Excel Discussion (Misc queries) | |||
| HELP! Making A Form | Excel Worksheet Functions | |||
| Making 2 similar fileds in form mirrir of each other. | Excel Discussion (Misc queries) | |||
| Keep a running total while using a clearable form | Excel Discussion (Misc queries) | |||
| Making form using Excell Help ASAP! | Excel Discussion (Misc queries) | |||
Hybrid Mode
