Results 1 to 3 of 3
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Can't figure out the formula on this one (97 or gr

    See the attached version. I have added formulas in column N to calculate the cumulative volume, and used the result to calculate the density. You can hide column N in the definitive version.

  2. #2
    3 Star Lounger
    Join Date
    Sep 2001
    Location
    Stuck at work..., Missouri, USA
    Posts
    248
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can't figure out the formula on this one (97 o

    That seems to be it, thank you.

    I had to look at the formulas about 10 times before I got the logic, but you've made it look so simple.

    Thank you.
    <font face="Comic Sans MS">Morgan Erickson</font face=comic>
    morgan.erickson@sprint.com
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18>-From <img src=/S/flags/Colorado.gif border=0 alt=Colorado width=30 height=18> but living in <img src=/S/flags/Missouri.gif border=0 alt=Missouri width=30 height=18>...and working in Kansas.

  3. #3
    3 Star Lounger
    Join Date
    Sep 2001
    Location
    Stuck at work..., Missouri, USA
    Posts
    248
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cant figure out the formula on this one - RESOLVED

    I have a spreadsheet for calculating the density of a package.

    I enter items by the line.

    If I have a weight in the item, I want the Total Density cell to calculate for that line plus the lines above it that have no weight.

    For example:
    Line 1 has a weight, so it would calculate.
    Line 2 has no weight so it would not calculate
    Line 3 has a weight so it sould calculate for line 2 & 3 combined.

    I have attached the spreadsheet for reference.

    Can anyone help me get the cormula correct?

    Thanks!
    <font face="Comic Sans MS">Morgan Erickson</font face=comic>
    morgan.erickson@sprint.com
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18>-From <img src=/S/flags/Colorado.gif border=0 alt=Colorado width=30 height=18> but living in <img src=/S/flags/Missouri.gif border=0 alt=Missouri width=30 height=18>...and working in Kansas.

Posting Permissions

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