Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert bytes to kilobytes or megabytes?
I have a list of files that include the file size listed in bytes. I need to
convert these files sizes into Megs or K's or leave them as bytes. For example what I have is... File name Size in bytes Tiny file 3 Medium file 153,600 Large file 5,242,880 What I need is... File name Size Tiny file 3 bytes Medium file 150k Large file 5 megs Any ideas? Thanks in advance Toney |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert bytes to kilobytes or megabytes?
=IF(A5<10^3,A5&"
bytes",IF(A5<10^6,ROUND(INT(A5/10^3),-1)&"k",ROUND(INT(A5/10^6),1)&" megs")) -- __________________________________ HTH Bob "Toney" wrote in message ... I have a list of files that include the file size listed in bytes. I need to convert these files sizes into Megs or K's or leave them as bytes. For example what I have is... File name Size in bytes Tiny file 3 Medium file 153,600 Large file 5,242,880 What I need is... File name Size Tiny file 3 bytes Medium file 150k Large file 5 megs Any ideas? Thanks in advance Toney |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert bytes to kilobytes or megabytes?
One kilobyte < 1000 bytes. (based on OP's example and result, he is using
the correct calculation of 1 kb = 2^10 bytes. =IF(A5<2^10,A5&" bytes",IF(A5<2^20,ROUND (INT(A5/2^10),-1)&"k",ROUND(INT(A5/2^20),1)&" megs")) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Bob Phillips" wrote: =IF(A5<10^3,A5&" bytes",IF(A5<10^6,ROUND(INT(A5/10^3),-1)&"k",ROUND(INT(A5/10^6),1)&" megs")) -- __________________________________ HTH Bob "Toney" wrote in message ... I have a list of files that include the file size listed in bytes. I need to convert these files sizes into Megs or K's or leave them as bytes. For example what I have is... File name Size in bytes Tiny file 3 Medium file 153,600 Large file 5,242,880 What I need is... File name Size Tiny file 3 bytes Medium file 150k Large file 5 megs Any ideas? Thanks in advance Toney |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert bytes to kilobytes or megabytes?
Thanks for your help. Between the two answers i figured out how to do this.
Thanks again Toney |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert bytes to kilobytes or megabytes?
Thanks for your help. Your reply was just a bit more spot on with the using
the 1024 byte/k. Between the two answers I figured out how to do this. Thanks again Toney |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert bytes to kilobytes or megabytes?
On Friday, September 11, 2009 at 1:16:02 PM UTC-7, Toney wrote:
Thanks for your help. Your reply was just a bit more spot on with the using the 1024 byte/k. Between the two answers I figured out how to do this. Thanks again Toney Sorry for the 9 year old thread resurrection, but here is an expansion that covers through petabytes in case anyone finds it useful :) =IF(A5<2^10,A5&" bytes",IF(A5<2^20,ROUND (INT(A5/2^10),-1)&"kb",IF(A5<2^30,ROUND (INT(A5/2^30),-1)&"mb",IF(A5<2^40,ROUND (INT(A5/2^30),-1)&"gb",ROUND(INT(A5/2^40),1)&" tb")))) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding bytes, gigabytes, and megabytes in Excel | Excel Worksheet Functions | |||
Time and megabytes | Excel Worksheet Functions | |||
0 bytes | Excel Discussion (Misc queries) | |||
How many bytes? | Excel Discussion (Misc queries) | |||
Add kilobytes to megabytes in the convert function | Excel Worksheet Functions |