+ Reply to Thread
Results 1 to 6 of 6

Parallel between values

Hybrid View

Leo37587 Parallel between values 02-20-2017, 11:32 PM
avk Re: Parallel between values 02-21-2017, 12:38 AM
Glenn Kennedy Re: Parallel between values 02-21-2017, 01:15 AM
Leo37587 Re: Parallel between values 02-21-2017, 02:08 AM
Leo37587 Re: Parallel between values 02-21-2017, 02:24 AM
avk Re: Parallel between values 02-21-2017, 02:28 AM
  1. #1
    Registered User
    Join Date
    05-10-2013
    Location
    Milano, Italy
    MS-Off Ver
    Excel 2003
    Posts
    11

    Parallel between values

    Dear all,

    if 337 pieces are equal to 1 CBM (m3) in Volume.

    Which formula can I use so that when I raise the quantity the Volume in CBM raises proportionally?

    Thanks!

    Bests

  2. #2
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,276

    Re: Parallel between values

    CBM stands for cubic meters.
    For CBM required : Length (cm), Breadth (cm), Height (cm), Weight (kg), Quantity.
    Whereas you mentioned only quantity (337).
    Note that, CBM calculated 4 ways.
    1) Calculating CBM per Rectangular Prism
    2) Calculating CBM per Cylindrical Unit
    3) Calculating CBM per Irregular Unit
    4) Calculating CBM per Total Shipment


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Parallel between values

    Is this what you mean? If the no of units is in A1 =A1/337
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  4. #4
    Registered User
    Join Date
    05-10-2013
    Location
    Milano, Italy
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Parallel between values

    Sorry I try to clarify.

    One single Item measures 0.00297 CBM.

    So 1/0.00297 = 336.7 --> in a Cubic meter of space I can theoretically fit approx 337 items.

    So:

    (Qty)A1:337 (Volume,CBM)B1:1

    I would like to raise and lower the quantity in A1 and have an automatic adjustment in B1.

    Thanks.

  5. #5
    Registered User
    Join Date
    05-10-2013
    Location
    Milano, Italy
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Parallel between values

    Hi Glenn Kennedy,

    Actually you already provided the solution. So Simple! Shame on me...

    Thanks a lot.

  6. #6
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,276

    Re: Parallel between values

    Dear Leo
    Are you seen my post #2 its clear mentioned that, for cbm required : Length (cm), Breadth (cm), Height (cm), Weight (kg), Quantity.
    Your information not fulfill to calculated.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] make list of values corresponding to unique values in parallel list
    By johnandrews in forum Excel General
    Replies: 3
    Last Post: 11-18-2014, 09:46 AM
  2. Parallel Processing
    By BuffaloFan32 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-14-2014, 02:45 PM
  3. Replies: 0
    Last Post: 10-28-2013, 02:55 PM
  4. Replies: 3
    Last Post: 04-29-2013, 10:15 AM
  5. Labels on bar charts parallel
    By se7encm in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 08-23-2010, 04:21 AM
  6. Running two vba macros in parallel
    By Milos Setek in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-09-2008, 09:26 AM
  7. Looping across two parallel ranges
    By colin_e in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-01-2006, 07:25 PM

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