Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Round down to next $2.50

Topic Labels: Formulas
Solved
Jump to Solution
1102 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
18 - Pluto
18 - Pluto

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
18 - Pluto
18 - Pluto

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!