Skip to main content

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.

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!

Reply


Terms & Conditions