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.

Re: Round down to next $2.50

Solved
Jump to Solution
1059 0
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!