Return numbers to the nearest fraction

blank


A4 - (rounded down)
A5 - (rounded up)
A6 - (rounded down)
A7 - (rounded up)
A8 - (rounded down)
A9 - (rounded up)


 AB
112.4854.26
212.374.2
312.29123.456
4=ROUND(A1/0.2, 0)*0.2 = 12.4 
5=ROUND(A2/0.2, 0)*0.2 = 12.4 
6=ROUND(A3/0.2, 0)*0.2 = 12.2 
7=ROUND(B1/0.5, 0)*0.5 = 4.5 
8=ROUND(B2/50, 0)*50 = 50 
9=ROUND(B3/25, 0)*25 = 125 

Built-in Functions

ROUND - The number rounded to a specified number of digits.

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top