+ Reply to Thread
Results 1 to 5 of 5

Using excel to do conversions in volume

Hybrid View

  1. #1
    Registered User
    Join Date
    06-10-2013
    Location
    Alpharetta, Georgia
    MS-Off Ver
    Excel 2010
    Posts
    2

    Using excel to do conversions in volume

    I want to use Excel to convert from one volume unit to another (e.g. gallons to liters). I have a total of four units that I want to convert from / to. I want to use a drop down list for the "from" and "to" units. Each pair of units would have a unique conversion factor (e.g. gallons to liters would be 3.7854). In this example, if I have four (4) gallons, the number of liters = 4 x 3.7854.

    Once the user selects the "from" and "to" units, I want Excel to select the appropriate conversion factor. Is there a better way to do this than by nesting twelve IF statements? A lookup table maybe?

    Thanks for your help!

  2. #2
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: Using excel to do conversions in volume

    What are the four units ??
    Gary's Student

  3. #3
    Registered User
    Join Date
    06-10-2013
    Location
    Alpharetta, Georgia
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Using excel to do conversions in volume

    They are gallons, fluid ounces, liters, and milliliters.

  4. #4
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: Using excel to do conversions in volume

    See the attached............the pull-downs are in B1 and C1
    Attached Files Attached Files

  5. #5
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,657

    Re: Using excel to do conversions in volume

    Take a look at this simple example
    Change the green cells and see what happen
    Attached Files Attached Files
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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