Forum Discussion

ajmal_pottekattil_yoousuf's avatar
ajmal_pottekattil_yoousuf
Iron Contributor
Mar 23, 2023
Solved

Convert one Unit to Another

please refer the excel could you please guide me
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Mar 25, 2023

    NikolinoDE 

    If use lookup vector sorted in ascending order and adjust result vector accordingly, simple LOOKUP(), which is available for any version, works

    =F5*LOOKUP(G5&"-"&D5,{"µA-A","µA-mA","A-µA","A-A","A-mA","mA-µA","mA-A","mA-mA","μm-μm"},{0.000001,0.001,0.000001,1,0.001,1000,0.001,1,1})
NikolinoDE's avatar
NikolinoDE
Gold Contributor
Mar 23, 2023

ajmal_pottekattil_yoousuf 

You can convert milliampere values to ampere values in Excel by dividing them by 1000.

For example, if you have a cell A1 with 99 mA, you can enter this formula in another cell: =A1/1000. 

This will give you 0.099 A as the result.

 

To display the values with value designation, you can use a custom format that adds a suffix of A to the values.

To do this, select the cells with ampere values, right-click and choose Format Cells.

Then, go to the Number tab and select Custom from the Category list.

In the Type box, enter “0.000 \A” (without quotes) and click OK. 

This will show the values in ampere with a suffix of A.

 

See the example in the file you sent.

 

Hope I could help you with these information / links.

 

NikolinoDE

I know I don't know anything (Socrates)

ajmal_pottekattil_yoousuf's avatar
ajmal_pottekattil_yoousuf
Iron Contributor
Mar 23, 2023

 

 

NikolinoDE 

This field is a dynamic field.

User always change this value.

Based on that Convert the CMC-2 value to change to "Nominal Value Unit".

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Mar 23, 2023

    ajmal_pottekattil_yoousuf 

    You can use the CONVERT function in Excel to convert between different units of measurement.

    For example, if you want to convert 100 mA to A, you can use:

    CONVERT(100,"mA","A")

    which will return 0.1 A.

    Similarly, if you want to convert 0.5 A to mA, you can use:

    CONVERT(0.5,"A","mA")

    which will return 500 mA.

     

    You can also use this function in a dynamic field by referencing a cell that contains the number you want to convert. For example, if cell A1 has 100 mA and you want to convert it to A in cell B1, you can use:

    CONVERT(A1,"mA","A")

    in cell B1.

     

    I hope this helps.

Resources