Round down to next $2.50

[Niall_Bermingha]

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.

[TheTimeSavingCo · Accepted solution]

Try:

ROUNDDOWN(
  Value/2.50, 
  0
) 
* 2.50

[Niall_Bermingha]

This worked, thank you so much for your help!