rules for rounding tombungaloIt isn't pretty but this equation will work =ROUNDDOWN(C4,3)+MAX(INT(INT(MOD(C4*10000,10)-1)/3)*5,0)/10000 but that is only the special rounding you mentioned You then said the other 3 decimal places should follow normal rules, but you don't round to...