Electric Current Unit Converter in Excel
1 exaampere = 1.000000000E+021 milliampere
Formula for this pair
These units are a straight multiple of each other. Put the starting value in cell A1.
=A1*1.000000000E+021
Once you have saved the function below, type this in a cell
=ConvertElectricCurrent(1, "EA", "mA")
CONVERT
Excel's CONVERT function does not cover this quantity. Use the formula above. It uses this site's conversion factors.
How to save as a reusable Excel function
Microsoft 365. No VBA and no add-in.
- Open the function below and copy it. It has no call at the end.
- On the Formulas tab, choose Name Manager, then New.
- Set the name to ConvertElectricCurrent. Leave the scope as Workbook.
- Paste the function into Refers to.
- In a cell, type the call shown above.
ConvertElectricCurrent
Show the full function
=LAMBDA(value,from_unit,to_unit,LET(fromFactor,SWITCH(from_unit,"A",1,"EA",1000000000000000000,"GA",1000000000,"MA",1000000,"TA",1000000000000,"cA",0.01,"dA",0.1,"fA",1E-15,"kA",1000,"mA",0.001,"nA",1E-9,"pA",1E-12,"uA",0.000001),fromShift,SWITCH(from_unit,"A",0,"EA",0,"GA",0,"MA",0,"TA",0,"cA",0,"dA",0,"fA",0,"kA",0,"mA",0,"nA",0,"pA",0,"uA",0),toFactor,SWITCH(to_unit,"A",1,"EA",1000000000000000000,"GA",1000000000,"MA",1000000,"TA",1000000000000,"cA",0.01,"dA",0.1,"fA",1E-15,"kA",1000,"mA",0.001,"nA",1E-9,"pA",1E-12,"uA",0.000001),toShift,SWITCH(to_unit,"A",0,"EA",0,"GA",0,"MA",0,"TA",0,"cA",0,"dA",0,"fA",0,"kA",0,"mA",0,"nA",0,"pA",0,"uA",0),(value*fromFactor+fromShift-toShift)/toFactor))
Conversion factors
The factors this converter uses. Copy them into Excel as tab-separated values.
| Symbol | Name | Factor | Excel code |
|---|---|---|---|
| A | ampere | 1 | — |
| EA | exaampere | 1000000000000000000 | — |
| GA | gigaampere | 1000000000 | — |
| MA | megaampere | 1000000 | — |
| TA | teraampere | 1000000000000 | — |
| cA | centiampere | 0.01 | — |
| dA | deciampere | 0.1 | — |
| fA | femtoampere | 1E-15 | — |
| kA | kiloampere | 1000 | — |
| mA | milliampere | 0.001 | — |
| nA | nanoampere | 1E-9 | — |
| pA | picoampere | 1E-12 | — |
| uA | microampere | 0.000001 | — |
Google Sheets
Google Sheets has CONVERT and many of the same codes, and it has LAMBDA. Named functions are created under Data > Named functions, not Formulas > Name Manager. A code that works in Excel can return #N/A in Sheets, so try a known value before you rely on it.