- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 21, 2023 11:05 AM
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!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 21, 2023 12:48 PM
Ellis...
Does this accomplish what you are trying to do?
If so, the formula is just
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 22, 2023 01:15 AM
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!
