| Bytes | Formula: =A2/(1024)^(FLOOR(log(A2)/log(1024))) |FLOOR(log(A2)/log(1024)|=SWITCH( FLOOR( log(A2) / log(1024) ) ,0,"Bytes",1,"KiB",2,"MiB",3,"GiB",4,"TiB")| All in one | All in one rounded to 2 decimal | |----------------|------------------------------------------------|---|-------|----------------------|---------------------------------| | 512 | 512 | 0 | Bytes | 512 Bytes | 512 Bytes | | 1024 | 1 | 1 | KiB | 1 KiB | 1 KiB | | 2048 | 2 | 1 | KiB | 2 KiB | 2 KiB | | 4096 | 4 | 1 | KiB | 4 KiB | 4 KiB | | 1,048,576 | 1 | 2 | MiB | 1 MiB | 1 MiB | | 36,068,183 | 34.39729977 | 2 | MiB | 34.3972997665405 MiB | 34.4 MiB | | 148,503,136 | 141.6236267 | 2 | MiB | 141.623626708984 MiB | 141.62 MiB | | 1,377,849,741 | 1.283222568 | 3 | GiB | 1.28322256822139 GiB | 1.28 GiB | | 4,242,623,877 | 3.951251392 | 3 | GiB | 3.95125139225274 GiB | 3.95 GiB | | 24,935,584,458 | 23.22307272 | 3 | GiB | 23.2230727169663 GiB | 23.22 GiB | | 27,298,486,746 | 25.42369696 | 3 | GiB | 25.4236969593912 GiB | 25.42 GiB | | 27,298,486,746 | 25.42369696 | 3 | GiB | 25.4236969593912 GiB | 25.42 GiB |