View Single Post
  #2   Report Post  
David Billigmeier
 
Posts: n/a
Default

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

--
Regards,
Dave


"Matt Thompson" wrote:

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/comm...et.f unctions