Round Prices Up or Down

Ask the Community Formulas
#1

I am creating a pricing table in Stackby where I need to round my product prices to the nearest 0.25:

  • ROUNDUP: I want the price to always round up to the nearest 0.25.
  • ROUNDDOWN: I want the price to always round down to the nearest 0.25.

Could anyone help me with the formula to achieve this?

#2

Hey Harsh,
To round prices up or down to the nearest 0.25 in Stackby, you can use the following formula columns with the ROUNDUP or ROUNDDOWN functions.

ROUNDUP({Price} * 4, 0) / 4
ROUNDDOWN({Price} * 4, 0) / 4

Example:

If the value of {Price} is 1.33: