Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save lktslionel/1ed833ae8d4badba7db57656f3874907 to your computer and use it in GitHub Desktop.
Save lktslionel/1ed833ae8d4badba7db57656f3874907 to your computer and use it in GitHub Desktop.
Excel formula to convert Byte to K, M, G
=SI(
DROITE(SUPPRESPACE(SUBSTITUE(C4;".";",")))="K";
PRODUIT(
CNUM(GAUCHE(SUPPRESPACE(SUBSTITUE(C4;".";","));NBCAR(SUPPRESPACE(SUBSTITUE(C4;".";",")))-1));
1024
);
SI(
DROITE(SUPPRESPACE(SUBSTITUE(C4;".";",")))="M";
PRODUIT(
CNUM(GAUCHE(SUPPRESPACE(SUBSTITUE(C4;".";","));NBCAR(SUPPRESPACE(SUBSTITUE(C4;".";",")))-1));
1024;1024
);
SI(
DROITE(SUPPRESPACE(SUBSTITUE(C4;".";",")))="G";
PRODUIT(
CNUM(GAUCHE(SUPPRESPACE(SUBSTITUE(C4;".";","));NBCAR(SUPPRESPACE(SUBSTITUE(C4;".";",")))-1));
1024;1024;1024
);
"N/A"
)
)
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment