Hello (<-- two spaces)
World
Hello
World
rschuman
/ A_one_line_formula.md
Created
December 16, 2024 15:54
— forked from seb26/A_one_line_formula.md
This formula can be used in Google Sheets to take a value in bytes and then represent it in a human-readable format with binary units (KiB, MiB, GiB, and so on).
=ROUND( A2/(1024)^(FLOOR(log(A2)/log(1024))), 2) & " " & SWITCH( FLOOR( log(A2) / log(1024) ) ,0,"Bytes",1,"KiB",2,"MiB",3,"GiB",4,"TiB")