AnsweredAssumed Answered

Conditional rounding

Question asked by ultranix on Nov 17, 2013
Latest reply on Nov 18, 2013 by ultranix

Title

Conditional rounding

Post

     Hey,

     I have conditional rounding question, that i cannot solve by myself.

     Base calculation field formula looks like this:

     Case (price_now  ≥  150; //ROUND TO 5, i.e. 155, 160, 165//;
     Case (price_now  ≥  50; //ROUND TO 2,5, i.e. 52.5, 55, 57,5//;
     Case (price_now > 10; //ROUND TO 1 i.e. 11, 12, 13//;
     Case (price_now > 0; //ROUND TO 0,5, i.e. 1, 1,5, 2, 2,5//;))))

     How could i round to the mentioned measurements?

Outcomes