Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Help creating a Function

  1. #1
    New Member
    Join Date
    Sep 2012
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Help creating a Function

    I have to create 3 different functions for class. I have to be able to create a function that converts metrics to English that is provided in a predefined drop down list. I need help with this and my assignment is due Monday morning so please help! Im beyond frustrate as I cant figure this out So I below are the metrics that are in the drop down list that I need to create the 1st function to return a value, then I also included the formulas we have to use to get
    the conversions, and then the last function will be similar to the 1st one to return a value from the drop down list.

    So for example if we are doing the 1st option from the dropdown list then I would need the 1st function to return a value of "pounds" then I need a function to return a value of the formula and the last function will need to return the value of "kilograms" . Please not that these functions need to work with whatever selection is made from the dropdown list w/ all the options I provided below.

    Metrics Formulas
    Pounds to Kilograms pounds * .4536
    Kilograms to Pounds kilograms * 2.2
    Inches to Centimeters 2.54*inches
    Centimeters to Inches 0.3937*centimeters
    Farenheit to Celsius ((farenheit - 32) * (5 / 9))
    Celsius to Farenheit (1.8 * celsius) + 32
    Quarts to Liters quarts * .9464
    Liters to Quarts liters * 1.057
    Miles to Kilometers miles * 1.609
    Kilometers to Miles kilometers * .6214

  2. #2
    Board Regular
    Join Date
    Feb 2012
    Location
    Florida, USA
    Posts
    10,853
    Post Thanks / Like
    Mentioned
    16 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Help creating a Function

    Quote Originally Posted by misslady7270 View Post
    I have to create 3 different functions for class. I have to be able to create a function that converts metrics to English that is provided in a predefined drop down list. I need help with this and my assignment is due Monday morning so please help! Im beyond frustrate as I cant figure this out So I below are the metrics that are in the drop down list that I need to create the 1st function to return a value, then I also included the formulas we have to use to get
    the conversions, and then the last function will be similar to the 1st one to return a value from the drop down list.

    So for example if we are doing the 1st option from the dropdown list then I would need the 1st function to return a value of "pounds" then I need a function to return a value of the formula and the last function will need to return the value of "kilograms" . Please not that these functions need to work with whatever selection is made from the dropdown list w/ all the options I provided below.

    Metrics Formulas
    Pounds to Kilograms pounds * .4536
    Kilograms to Pounds kilograms * 2.2
    Inches to Centimeters 2.54*inches
    Centimeters to Inches 0.3937*centimeters
    Farenheit to Celsius ((farenheit - 32) * (5 / 9))
    Celsius to Farenheit (1.8 * celsius) + 32
    Quarts to Liters quarts * .9464
    Liters to Quarts liters * 1.057
    Miles to Kilometers miles * 1.609
    Kilometers to Miles kilometers * .6214
    If someone else does your homework for you, is that not defeating the purpose of taking the course?

  3. #3
    MrExcel MVP VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    63,651
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    8 Thread(s)

    Default Re: Help creating a Function

    We don't normally help with homework but Excel CONVERT Function Made Easy Contextures Blog may get you started.
    HTH, Peter
    Please test any code on a copy of your workbook.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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