Round down to next $2.50 | Airtable Community

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.

Page 1 / 1

Try:

ROUNDDOWN(
  Value/2.50, 
  0
) 
* 2.50

Try:

ROUNDDOWN(
  Value/2.50, 
  0
) 
* 2.50

This worked, thank you so much for your help!

Sign up