Amount Of Substance Unit Converter in Excel

From To

0.001

Add-in Formula =PO.UnitConverter(1, "mol", "kmol")

Excel Lambda

=LAMBDA(x,
  LET(
    ratio, 0.001,
    x * ratio
  )
)(1)

Category Lambda

=LAMBDA(x, from, to,
  LET(
    f, SWITCH(from,
      "mol", 1,
      "kmol", 1000,
      "lbmol", 453.59237,
      "mmol", 0.001,
      "umol", 1E-06),
    t, SWITCH(to,
      "mol", 1,
      "kmol", 1000,
      "lbmol", 453.59237,
      "mmol", 0.001,
      "umol", 1E-06),
    x * f / t
  )
)(1, "mol", "kmol")

How to save as a reusable Excel function

LAMBDA is a built-in Excel feature (Microsoft 365) that lets you create custom functions without VBA. The formulas above work as-is when pasted into a cell.

To save a LAMBDA as a reusable named function:

Go to Formulas → Name Manager → New
Enter a name, e.g. ConvertAmountOfSubstance
In Refers to, paste the LAMBDA formula without the trailing invocation (...)
Click OK

Now use =ConvertAmountOfSubstance(1, "mol", "kmol") anywhere in your workbook — no add-in required.

Conversion Factors (base: mol)

Unit	Name	Factor
mol	gram-mole	1
kmol	kilogram-mole	1000
lbmol	pound-mass-mole	453.59237
mmol	milligram-mole	0.001
umol	microgram-mole	1E-06