1 Reply Latest reply on Nov 20, 2013 4:37 PM by Insight

    Round Prescient to the nearest 5%

    Insight

      Hi

       

      I'm looking for calculation to round a prescientage to the nearest 5%

       

      So as we get 5% 10% 15 % 20% 25% 30% 35% 40% 45% 50% 55% 60% 65% 70% 75% 80% 85% 90% 100%

       

      found this explanation on filemaker forum but it doesnt work

       

      ---------

       

      To round to the nearest 5 as it is with weights in a fitness center (5, 10, 15, 20) you can take the number and use the Round () and Int () functions:


      Round ((Int (((Number) + 2.50) / 5) * 5), 0)

       

      ---------

       

      Any ideas ?

       

      Thanks in advance

       

      Bob