Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Convert currency with decimals into minor units number

Topic Labels: Formulas
1700 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Ellis
4 - Data Explorer
4 - Data Explorer

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 2
Ron_Daniel
8 - Airtable Astronomer
8 - Airtable Astronomer

Ellis...
Does this accomplish what you are trying to do?
Screen Shot 2023-02-21 at 3.47.22 PM.png

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!