Skip to main content

Convert currency with decimals into minor units number

  • February 21, 2023
  • 2 replies
  • 68 views
E
Forum|alt.badge.img+3

Hi, struggling with a formula for converting a currency field into minor units.

Example: Formula field adding two currency values (£50.45 & £40.20) gives value £90.65. I need a formula that returns this value as 9065 - but I cannot work it out.

In Excel it would be a simply TRUNC, but Airtable doesn't seem to have this feature. I'm amazed this question hasn't been asked before, but cannot find it anywhere!

2 replies

Ron_Daniel
Forum|alt.badge.img+21
  • Ron_Daniel
  • Inspiring
  • 105 replies
  • February 21, 2023

Ellis...
Does this accomplish what you are trying to do?

If so, the formula is just

({Value 1} + {Value 2}) * 100
E
Forum|alt.badge.img+3
  • Ellis11
  • Author
  • New Participant
  • 1 reply
  • February 22, 2023

Ellis...
Does this accomplish what you are trying to do?

If so, the formula is just

({Value 1} + {Value 2}) * 100

Thanks Ron, it doesn't quite (my fault, bad example) but I now realise why nobody has asked this question before as the answer is blindingly obvious and I feel like an idiot for asking it! I was looking for a way more complicated solution than required... Thanks again!


Terms & ConditionsAccessibility statement