Kolom mround berisi :
=MROUND(B2;0,25)
Kolom cheetah berisi :
=IF(ISNUMBER(SEARCH(",25";C2));REPLACE(C2;FIND(",25";C2);3;".");IF(ISNUMBER(SEARCH(",5";C2));REPLACE(C2;FIND(",5";C2);2;"..");IF(ISNUMBER(SEARCH(",75";C2));REPLACE(C2;FIND(",75";C2);3;"...");C2)))
1 comment:
=INT(C2)&REPT(".";(C2-INT(C2))/0,25)
Post a Comment