Forum Discussion
MROUND VS. FLOOR
Aloha I need to round to the next lower 5 the following numbers; 2100 (must be 2095) 1519 (must be 1515) 1393 (must be 1385) 1617 (must be 1615) Using MROUND works for some numbers, same with FLOOR, ...
Maybe you could try this (assuming your value to round is in A1
=IF( MOD(FLOOR(A1,5),10)=0, FLOOR(A1-5,5), FLOOR(A1,5) )