Results 1 to 2 of 2

How to use sigma problem for multiple server excel

Threaded View

  1. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: How to use sigma problem for multiple server excel

    Welcome to the board.

    Create named ranges L, u, and k

    Create named formula n refers to: =ROW(INDIRECT("1:" & k-1)) - 1

    Then

    Row\Col
    A
    B
    C
    1
    L
    6
    2
    u
    5
    3
    k
    3
    4
    P0
    0.316456
    B4: {=1/SUM( (L/u)^n / FACT(n) + (L/u)^k / FACT(k) * (k * u) / (k * u - L))}


    The curly braces mean that the formula MUST be confirmed with Ctrl+Shift+Enter instead of just Enter.
    Last edited by shg; 04-06-2016 at 06:53 PM.
    Entia non sunt multiplicanda sine necessitate

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Sigma Sum function with multiple variables
    By MVictorH in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-22-2015, 10:08 AM
  2. Multiple Sigma's working correctly in one formula
    By Ernst88 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-15-2014, 01:24 PM
  3. Excel add-in for SQL Server Analysis Services - Merge and Center problem
    By mclifford in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-31-2007, 03:39 PM
  4. Replies: 1
    Last Post: 04-26-2007, 10:36 PM
  5. Repost Excel Server Problem
    By shattarjain@yahoo.com in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-06-2005, 04:05 AM
  6. Replies: 0
    Last Post: 05-10-2005, 05:06 PM
  7. Excel Add-in for SQL Server Analysis Services - refresh problem
    By Inge M. Bruvik in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-03-2005, 04:07 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1