Round off Next 5

Help Activities
, , ,
1

Need help for below

i have value in once Variable like below

a=1793.43 i want to round up this value 1795 like function in excel ceilling
a=1792.40 i want to round up this value 1790 like function in excel ceilling

please help mi on this

2

Hi,

Can you try the following expression?

Math.Ceiling((Math.Floor(a/2.5)*2.5)/5)*5

It might be better to use Decimal type for accuracy.

Math.Ceiling((Math.Floor(a/2.5D)*2.5D)/5D)*5D

Regards,

3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.