Solved

Round down to next $2.50

+3

I'm having issues getting a formula to round down prices to the nearest $2.50.

I've tried FLOOR()

FLOOR({Price}, 2.5)

and ROUNDDOWN()

ROUNDDOWN({Price},2.5)

but without any success. Thank you in advance.

Best answer by TheTimeSavingCo

Try:

ROUNDDOWN(
  Value/2.50, 
  0
) 
* 2.50

+31

Try:

ROUNDDOWN(
  Value/2.50, 
  0
) 
* 2.50

Adam, Airtable Consultant - thetimesaving.company

+3

Try:

ROUNDDOWN(
  Value/2.50, 
  0
) 
* 2.50

This worked, thank you so much for your help!

Sign up