Add kilobytes to megabytes in the convert function

[Matt Thompson]

I always have to re-write the formula to convert kilobytes to megabytes to
gigabytes. It would be nice if excel had this availible out of the box,
maybe in the convert function.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...dg=microsoft.public.excel.worksheet.functions

 

[David Billigmeier]

It shouldn't be that hard, multiply by increasing powers of 1024 (2^10) for
going up in memory, and divide by increasing powers of 1024 going backwards.
For example:

5402 Kilobytes in Gigabytes is equal to:

5402/1024^2 = 0.005151 GB

1 Gigabyte in Kilobytes is equal to:

1*1024^2 = 1,048,576 KB

 

[David Billigmeier]

Here is a UDF you could use as well:

Function ConvertMem(n As Double, from_mem As String, to_mem As String)
from_mem_num = getMemNum(from_mem)
to_mem_num = getMemNum(to_mem)
ConvertMem = n * 1024 ^ (from_mem_num - to_mem_num)
End Function


Function getMemNum(mem_string As String)
getMemNum = Switch(mem_string = "b", 1, mem_string = "k", 2, mem_string =
"m", 3, mem_string = "g", 4, mem_string = "t", 5)
End Function