Insight

Round Prescient to the nearest 5%

Discussion created by Insight on Nov 20, 2013
Latest reply on Nov 20, 2013 by 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

Outcomes