Results 1 to 24 of 24

Ratio between Sum of Columns is not logical

Threaded View

  1. #1
    Registered User
    Join Date
    04-16-2017
    Location
    Israel
    MS-Off Ver
    2007
    Posts
    11

    Post Ratio between Sum of Columns is not logical

    Hi.
    I have an excel table with three Columns. Each cell in column 3 is a multiplier of constant between 3.57 and 3.78 and the first column. The constants are in the second column.
    i.e. col1 * col2= col 3
    this is the table:

    Col1 ____ Col2 ____ Col3
    -2027.47 ____ 3.75 ____ -7594.77
    -3095.82 ____ 3.74 ____ -11582.71
    -528.97 ____ 3.78 ____ -2001.17
    -559.33 ____ 3.78 ____ -2114.5
    -579.34 ____ 3.70 ____ -2142.5
    -1017.48 ____ 3.70 ____ -3762
    -1025.66 ____ 3.70 ____ -3790
    -2023.24 ____ 3.71 ____ -7498.37
    641.74 ____ 3.69 ____ 2371
    919.03 ____ 3.60 ____ 3305.79
    -11042 ____ 3.73 ____ -41160.98
    -5890.66 ____ 3.73 ____ -21999.76
    -2275.86 ____ 3.74 ____ -8509.4
    -8537.12 ____ 3.73 ____ -31883.45
    -6639.5 ____ 3.73 ____ -24796.45
    -10248.6 ____ 3.73 ____ -38221.73
    -5000.81 ____ 3.71 ____ -18576.77
    -5020.84 ____ 3.71 ____ -18651.18
    -1617.82 ____ 3.73 ____ -6039.96
    5796.17 ____ 3.59 ____ 20788.78
    10483.96 ____ 3.59 ____ 37602.16
    917.89 ____ 3.57 ____ 3272.66
    7420.43 ____ 3.59 ____ 26614.4
    11283.23 ____ 3.59 ____ 40468.85
    -748.56 ____ 3.70 ____ -2767.6
    -40.05 ____ 3.70 ____ -148
    -10029.42 ____ 3.70____ -37107
    4954.66 ____ 3.58 ____ 17735.51
    2894.89 ____ 3.70 ____ 10707
    2011.03 ____ 3.57 ____ 7187.1
    4117.92 ____ 3.57 ____ 14716.46
    8387.64 ____ 3.57 ____ 29978.81

    -18119.96 ____ 4.17 ____ -75599.78

    The last row contains the sum of Col1 and Col3. But when I calculate the ratio between the 2 sums it is 4.17!!!!
    How can it be when the max ratio between each column cell is a max of 3.78??
    Please help
    Thanks in advance.
    Last edited by RamPowered; 04-16-2017 at 07:22 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Change the ratio between the columns and the gaps between them, stacked column char
    By Trebor777 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-22-2016, 10:41 AM
  2. Index Match Based on Ratio of Two Columns
    By AK de FLA in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-25-2016, 09:36 PM
  3. How to calculate a number based on the given ratio. For example a 2:3 ratio.
    By Ayoub99k in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-11-2015, 08:15 AM
  4. Replies: 1
    Last Post: 07-31-2013, 07:58 AM
  5. [SOLVED] Measurement for highest value and ratio between two columns
    By Zarlex in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-23-2013, 07:59 AM
  6. Excel 2007 : Create logical columns and refer it
    By sudhakarnraju in forum Excel General
    Replies: 5
    Last Post: 12-31-2010, 03:00 PM
  7. Divide x/y should give Ratio x:y,How to express ratio in excel
    By arvind3738 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-10-2006, 03:29 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