Jos,
lnNum=87
lnRoundTo=5
?MAX(1, FLOOR(lnNum/lnRoundTo)*lnRoundTo + IIF(MOD(lnNum,lnRoundTo)=>lnRoundTo/2, lnRoundTo, 0))
>Hi All,
>
>Having a bit of a brain freeze here...I have an integer between 0 and 100. I want to round it to the nearest integer wholly divisible by 5 i.e. 0,5,10,15,...95,100
>
>Sorry for the low quality challenge :)
Daniel