Aug 31, 2018 09:54 AM
I’m trying to use the Ceiling function to round a function result up to the nearest quarter, so 0.25. But my results are only rounding to the next 0.10.
How do I get it to always round up to the nearest .25, .50, .75, .00? It works like this in Excel but can’t seem to get it to work in airtable.
Feb 14, 2019 04:51 PM
I’m seeing similar odd results. Some ceiling values work fine, while others don’t:
Looks like it’s time for a bug report!
Feb 15, 2019 03:22 PM
@Jesse_Poteet I received a reply from support. They’ve logged it to fix, and passed along this workaround that appears to do the trick for now:
Here’s an example that I ran to confirm, using this formula:
Feb 15, 2019 08:21 PM
@Justin_Barrett hanks man. Yeah they had sent me the same fix so I’ve been using that and it’s working fine. They said back in August that it was reported and being worked on, but I guess not haha.
Jun 17, 2021 02:15 PM
Finally needed to use the Ceiling function for the first time in Airtable today.
I can confirm that this still does not operate in the same way as it does in Excel for example.
The workaround shared here in this topic helped me to get it working as intended.
Just wanted to provide an update with this information. :grinning:
May 18, 2022 01:47 AM
Just found your ancient post about the workaround concerning the CEILING() function. After I ran into the same problem I wanted to let you know that this bug is still there…