{{ message }}

Instantly share code, notes, and snippets.

# loganvolkers/Byte Formatting for Google Sheets.md

Last active Jul 28, 2022

### kaustubhcs commented May 18, 2021

How do you use this formatting?

### kaustubhcs commented May 19, 2021 • edited

Created a better one based on IF ELSE ladder.
The cell this will format is `F3`

``````=IF(F3<(1024), F3 & " B", IF(F3<(1024*1024), QUOTIENT(F3,1024) & " KB", IF(F3<(1024*1024*1024), QUOTIENT(F3,(1024*1024)) & " MB", IF(F3<(1024*1024*1024*1024), QUOTIENT(F3,(1024*1024*1024)) & " GB", IF(F3<(1024*1024*1024*1024*1024), QUOTIENT(F3,(1024*1024*1024*1024)) & " TB", "H")))))
``````

### varenc commented Jun 20, 2021 • edited

kaustubhcs that works as a formula, and is nice for using actual binary bytes, but there's advantages to using a custom number format instead of a formula! (no secondary cell, copied values are still the original byte count, etc).

### Smart123s commented Jul 4, 2021

Helped me out a lot. Thank you! :)

### eljeko commented Sep 14, 2021

Is what I was looking for, thank you!

### fordsho commented Sep 17, 2021

Thank you so much for this, It made my life so much easier!!

### caio-vinicius commented Sep 22, 2021

Thank you very much!

### alexstorer commented Oct 1, 2021

This is very useful! I can only get it to format 3 options, so if you want the MB/GB/TB version instead of the KB/MB/GB version, this looks like it works:

`[<1000000000]0.00,," MB";[<1000000000000]0.00,,," GB";0.00,,,," TB"`

### pkowaluk commented Apr 1, 2022

Nice work, OP. Thanks 🌟

Many thanks.