自动转换TB及GB

=IF(ISNUMBER(SEARCH("TB", A2)), VALUE(LEFT(A2, FIND(" ", A2))) * 1024 & " GB", A2)

更改单位大小的动态公式，单位为KB、MB、GB、TB等

=IF(A1<1024, A1&"B", IF(A1<1048576, ROUND(A1/1024, 2)&"KB", IF(A1<1073741824, ROUND(A1/1048576, 2)&"MB", IF(A1<1099511627776, ROUND(A1/1073741824, 2)&"GB", ROUND(A1/1099511627776, 2)&"TB"))))

---