Converting Kb to Gb what is the correct formula?

Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Converting Kb to Gb what is the correct formula?

  1. #1
    Board Regular
    Join Date
    Jul 2002
    Posts
    1,566
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Converting Kb to Gb what is the correct formula?

     
    Hello All,

    I have the following info in cell A:

    Total Storage Used -KB
    5819206640
    4044259328
    16867651584

    I want to convert these to Gb. What is the correct formula please?

    Thanks,

    Kurt
    When we all learn from each other the world becomes a very great place!

  2. #2
    Board Regular
    Join Date
    Jul 2002
    Posts
    1,566
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Converting Kb to Gb what is the correct formula?

    Would it be

    Code:
    A1/(1024*1024*1024)
    To convert Kb to Gb?
    When we all learn from each other the world becomes a very great place!

  3. #3
    Board Regular
    Join Date
    May 2008
    Posts
    836
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Converting Kb to Gb what is the correct formula?

    =A1/(1024^2)
    if A1 is KB, the above expression will result in GB

  4. #4
    Board Regular Barry Katcher's Avatar
    Join Date
    Feb 2002
    Location
    Dog Beach, Florida. Yeaahh!
    Posts
    4,053
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Converting Kb to Gb what is the correct formula?

    You're not going from bytes to gigabytes, but from kilobytes to gigabytes. Just use:

    A1/(1024*1024)

    or

    A1/1,048,576.

    Correct me I'm wrong, guys.
    Barry-

    Photo Restoration/Enhancement

    http://www.smiledogproductions.com
    click below for detour


  5. #5
    Board Regular
    Join Date
    Jul 2002
    Posts
    1,566
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Converting Kb to Gb what is the correct formula?

    Hello cm,

    Thanks that's it!

    Kurt
    When we all learn from each other the world becomes a very great place!

  6. #6
    Board Regular
    Join Date
    Jul 2002
    Posts
    1,566
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Converting Kb to Gb what is the correct formula?

    So to get it in Terabyets it would be:

    Code:
    C32/(1024^3)
    Correct?
    When we all learn from each other the world becomes a very great place!

  7. #7
    Board Regular
    Join Date
    May 2008
    Posts
    836
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Converting Kb to Gb what is the correct formula?

    Quote Originally Posted by Kurt View Post
    So to get it in Terabyets it would be:

    Code:
    C32/(1024^3)
    Correct?
    Yup, you got it.

  8. #8
    Board Regular
    Join Date
    Jul 2002
    Posts
    1,566
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Converting Kb to Gb what is the correct formula?

    Many thanks.

    Have a great weekend. Christmas and Happy New Year!

    Kurt
    When we all learn from each other the world becomes a very great place!

  9. #9
    New Member
    Join Date
    Sep 2010
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Converting Kb to Gb what is the correct formula?

    HI

    you should see this bytes converter
    http://mon-ip.awardspace.com/converter.php

  10. #10
    New Member
    Join Date
    Jan 2013
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Converting Kb to Gb what is the correct formula?

      
    How to convert GB to KB in excel 2007. I have many values in GB and i need to convert the same in KB using excel formulas.

    Please help.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com