Help

Round down to next $2.50

Topic Labels: Formulas
Solved
Jump to Solution
513 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Niall_Bermingha
4 - Data Explorer
4 - Data Explorer

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.

1 Solution

Accepted Solutions
TheTimeSavingCo
17 - Neptune
17 - Neptune

Try:

ROUNDDOWN(
  Value/2.50, 
  0
) 
* 2.50

Screenshot 2023-02-27 at 11.10.13 AM.png

See Solution in Thread

2 Replies 2
TheTimeSavingCo
17 - Neptune
17 - Neptune

Try:

ROUNDDOWN(
  Value/2.50, 
  0
) 
* 2.50

Screenshot 2023-02-27 at 11.10.13 AM.png

This worked, thank you so much for your help!