
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 07, 2020 09:30 AM
How can I achieve the FLOOR.MATH function that exists in Excel into Airtable?
FLOOR and ROUNDDOWN are not taking the precision as I expect.
I would like floor with a 0.25 precision:
FLOOR.MATH(11.78, 0.25) is returning 11.75
whereas in Airtable:
FLOOR (11.78, 0.25) is returning 11.80
ROUNDDOWN(11.78, 0.25) is returning 11.25
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 07, 2020 09:55 AM
A while back I discovered a problem with the CEILING()
function, and was given a workaround by one of the Airtable staff:
CEILING(number/significance)*significance
A quick test shows that the same works for FLOOR()
FLOOR(number/significance)*significance
In your case, that would be
FLOOR(11.78 / 0.25) * 0.25

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 07, 2020 09:55 AM
A while back I discovered a problem with the CEILING()
function, and was given a workaround by one of the Airtable staff:
CEILING(number/significance)*significance
A quick test shows that the same works for FLOOR()
FLOOR(number/significance)*significance
In your case, that would be
FLOOR(11.78 / 0.25) * 0.25
