Advertisement
Guest User

Untitled

a guest
Jun 10th, 2017
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. =IF(B1 < 1024;
  2.     CONCATENATE(B1;" B");
  3.     IF(B1 < 1048576;
  4.         CONCATENATE(ROUND(B1 / 1024; 2); " KB");
  5.         IF(B1 < 1073741824;
  6.             CONCATENATE(ROUND(B1 / 1048576; 2); " MB");
  7.             IF (B1 < 1099511627776;
  8.                 CONCATENATE(ROUND(B1 / 1073741824; 2); " GB");
  9.                 CONCATENATE(ROUND(B1 / 1099511627776; 2); " TB")
  10.             )
  11.         )
  12.     )      
  13. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement