5 Replies Latest reply: Jul 10, 2014 6:31 PM by PAUL YEO RSS

    How to round the last 2 decimal either 0.50 or 0.00 ?

    PAUL YEO

      Hi All

       

       

      I need to make :-

      71.15 to 71.50

      83.34 to 83.5

      95.54 to 95

       

       

       

       

      Below is my expression :-

       

       

      Ceil(

      If( column(1)>10,Round( column(1)), column(1))

      ,0.5)

       

       

      it does not work. hope some expert here can help me pls.

       

       

      Paul