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.

FLOOR.MATH Excel function equivalence

Topic Labels: Formulas
Solved
Jump to Solution
4341 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Marie-Helene_He
4 - Data Explorer
4 - Data Explorer

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

1 Solution

Accepted Solutions
Justin_Barrett
18 - Pluto
18 - Pluto

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

Screen Shot 2020-05-07 at 9.54.41 AM

Screen Shot 2020-05-07 at 9.55.05 AM

See Solution in Thread

1 Reply 1
Justin_Barrett
18 - Pluto
18 - Pluto

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

Screen Shot 2020-05-07 at 9.54.41 AM

Screen Shot 2020-05-07 at 9.55.05 AM