Convert number to nearest multiple of Five
Hello,
Is there a way that I can convert a number to its nearest multiple of
5?
like in A1.. A5 i have
281
288
291
297
298
I want in B1 .. B5
280
290
290
295
300
That is up the number or down to nearest multiples of five
Thanks
|