Forum Discussion
Convert one Unit to Another
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})
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".
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.
CONVERT function
Works in Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel 2016 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel for Mac 2011, Excel Starter 2010.Please, see the file with exambles.Link: How to Use CONVERT
Ampere is not part of the measurement systems supported by CONVERT().
=F5*XLOOKUP(G5&"-"&D5,{"μm-μm","µA-mA","µA-A","mA-µA","mA-mA","mA-A","A-µA","A-mA","A-A"},{1,0.001,0.000001,1000,1,0.001,0.000001,0.001;1})
