>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 :)
Thanks guys - Hilmar hit found what I was looking for!
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.