ExcelでKB,MB,GBで表示したい

これか

=IF(LEN(A1)<3,INT(A1*100)/100&"B",IF(LEN(A1)<6,INT((A1/1024)*100)/100&"KB",IF(LEN(A1)<9,INT((A1/1024/1024)*100)/100&"MB",IF(LEN(A1)<12,INT((A1/1024/1024/1024)*100)/100&"GB",IF(LEN(A1)<15,INT((A1/1024/1024/1024/1024)*100)/100&"TB",IF(LEN(A1)<18,INT((A1/1024/1024/1024/1024/1024)*100)/100&"PB"))))))

これでどうかな

=IF(LEN(A1)<4,INT(A1*100)/100&"B",IF(LEN(A1)<7,INT((A1/1024)*100)/100&"KB",IF(LEN(A1)<10,INT((A1/1024/1024)*100)/100&"MB",IF(LEN(A1)<13,INT((A1/1024/1024/1024)*100)/100&"GB",IF(LEN(A1)<16,INT((A1/1024/1024/1024/1024)*100)/100&"TB",IF(LEN(A1)<19,INT((A1/1024/1024/1024/1024/1024)*100)/100&"PB","FUGE DATA"))))))

via:http://trackback.blogsys.jp/livedoor/yoshio_will/51901808