Skip to content

Instantly share code, notes, and snippets.

@C-Duv

C-Duv/LibreofficeCalc-KiB-to-UpperBinaryPrefixes

Created December 13, 2013 12:18
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save C-Duv/7943455 to your computer and use it in GitHub Desktop.
Save C-Duv/7943455 to your computer and use it in GitHub Desktop.
Download ZIP
Pour LibreOffice Calc : Convertir des Kio en Kio, Mio, Gio, Tio tout en affichant l'unité. Notes : * Dans l'exemple, les Kio sont contenu dans la cellule A1 * Un arrondi est effectué (peut être retiré sans impact autre que visuel)
Raw
LibreofficeCalc-KiB-to-UpperBinaryPrefixes
=SI(
A1/1024>=1;
SI(
A1/1024/1024>=1;
SI(
A1/1024/1024/1024>=1;
CONCATENER(ARRONDI(A1/1024/1024/1024;3);" Tio");
CONCATENER(ARRONDI(A1/1024/1024;3);" Gio")
);
CONCATENER(ARRONDI(A1/1024;3);" Mio")
);
CONCATENER(ARRONDI(A1;3);" Kio")
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment