Help

FLOOR.MATH Excel function equivalence

Topic Labels: Formulas
Solved
Jump to Solution
4211 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