Results 1 to 2 of 2

Need help in a sequencing formula, cant figure how to extend to additional values.

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-29-2018
    Location
    United states
    MS-Off Ver
    2019
    Posts
    243

    Need help in a sequencing formula, cant figure how to extend to additional values.

    Ok so I have NO idea how to do this, in di sheet under J3:J6 I have these formulas

    =$H4^2 / ($H4^2+F$4*$H4+$F$4*$F$5)
    =$F$4*$H4 / ($H4^2+$F$4*$H4+$F$4*$F$5)
    =$F$4*$F$5 / ($H4^2+$F$4*$H4+$F$4*$F$5)

    These calculate the 2 values in C4, C5

    Now when I need to calculate 3 values C4:C6 as in the Tri sheet under J3:J7 the formula becomes

    =$H4^3 / ($H4^3+($F$4*$H4^2)+($F$4*$F$5*$H4)+($F$4*$F$5*$F$6))
    =$F$4*$H4^2 / ($H4^3+($F$4*$H4^2)+($F$4*$F$5*$H4)+($F$4*$F$5*$F$6))
    =$F$4*$F$5*$H4 / ($H4^3+($F$4*$H4^2)+($F$4*$F$5*$H4)+($F$4*$F$5*$F$6))
    =$F$4*$F$5*$F$6 / ($H4^3+($F$4*$H4^2)+($F$4*$F$5*$H4)+($F$4*$F$5*$F$6))

    What I dont know is how to make the required formulas to calculate
    4 values C4:C7 in the Quad sheet
    5 values C4:C8 in the Penta sheet
    6 values c4:c9 in the Hexa sheet

    Can some one help me out extending the formula to calculate the 6 values in the Hexa sheet please.

    I see a slight pattern, however i can not figure out how it extends.

    Please help
    Brad
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculate Figure Based off 3 Values : Complex Formula?
    By Rimberaud in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-07-2014, 06:48 AM
  2. [SOLVED] Formula that Assesses student for best figure/grade and addes additional information
    By Doofus1 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-05-2014, 03:34 PM
  3. Replies: 1
    Last Post: 02-06-2014, 03:00 PM
  4. Sum formula to exclude monthly budget figure when actual figure is entered
    By rocketmail in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-02-2013, 04:22 AM
  5. Replies: 3
    Last Post: 06-14-2012, 09:18 AM
  6. Sequencing numbers in a formula.
    By sleazyfish in forum Excel General
    Replies: 3
    Last Post: 06-09-2009, 06:36 AM
  7. [SOLVED] Formula for Sequencing Totals
    By Jeff T in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 01-24-2005, 08:06 PM

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