=ROUND(5.67*2,0)/2 is better than =ROUND(5.67/5,1)*5 because you should prefer powers of 2 (floating numbers are being represented without rounding errors)

=INT(100.578125)&REPT("-"&INT(MOD(100.578125,1)*32)&REPT (CHAR(187+INT((MOD(100.578125,1)-INT(MOD(100.578125,1)*32 )/32)*128)),INT((MOD(100.578125,1)-INT(MOD(100.578125,1)*32 )/32)*128)>0),INT(MOD(100.578125,1)*128)>0) Please note that this formula shows the highest tradeable price which is lower or equal to the input

Round a date time to an hour

26/04/2010 16:37:12 -> 26/04/2010 17:00:00

=ROUND("26/04/2010 16:37:12"*24,0)/24

Round a date time to next 10 min point

26/04/2010 16:37:12 -> 26/04/2010 16:40:00

=ROUND("26/04/2010 16:37:12"*24*6,0)/24/6

Round to 1/8 but show 1/4,1/2,3/4 instead of 2/8,4/8,6/8