Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Microsoft excel help

  1. Apr 24, 2007 #1
    this is rather embarrassing, but it's late, i have a headache and can't figure this out.

    so i have this complicated function i need to sum (not sum as in add up - sum as in sum a series).
    my formula that needs to be summed:

    pi, z, L, k, t are constants, i want sum n from 1 to 10... i looked through all the "sum" functions but i couldnt find a summation in which i could enter a function to be summed.

  2. jcsd
  3. Apr 25, 2007 #2

    Dr Transport

    User Avatar
    Science Advisor
    Gold Member

    Set the first column to the numbers 1 thru 10, then in the second column, set up your formulas for each n and sum down the column.
  4. Apr 26, 2007 #3
    So, I was waiting for somebody to say it... :)

    In my opinion, spreadsheet is a braindead tool for any computation past what you'd jot on a piece of paper in a grocery store. If one doesn't intend to compute anything more complicated than that in the nearby future, spreadsheet might be a reasonable way to go.

    Otherwise, I recommend switching to a tool that could support exactly what OP originally had in mind (passing one function to another), and, say, doesn't require more than flicking one number in order to increase or decrease the number of terms in the summation. Which would be just about any tool, e.g. the ubiquitous Matlab.

    Chusslove Illich (Часлав Илић)
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook

Similar Threads - Microsoft excel help Date
What should be the rules to write excellent code? Mar 12, 2018
Microsoft Visual Studio C++ error Nov 9, 2012
Anti-Microsoft rant May 21, 2012
Fortran files in Microsoft Visual Studio Feb 29, 2012
Microsoft Access 2007 question Sep 22, 2008