excel b kb mb gb 转换

点击查看代码

=IF(A1>POWER(1024,4),TRUNC(A1/POWER(1024,4),2)&" TB", IF(A1>POWER(1024,3),TRUNC(A1/POWER(1024,3),2)&" GB", IF(A1>POWER(1024,2), ROUND(A1/POWER(1024,2),0)&" MB", ROUND(A1/1024,0)&" KB")))

[<1000]##0,00" B";[<1000000]##0,00." KB";##0,00.." MB" 

[<1000000000000]##0,00..." GB";[<1000000000000000]##0,00...." TB";#.##0,00....." PB"