Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

COnvert Memory  to GB

Posted on 2016-10-20
3
Medium Priority
?
35 Views
Last Modified: 2016-11-09
i am using a from to display memory status and usage.i would like to have it converted as GB displayed in the task manager.I need a formula that will convert  2147483647  to gb.

thanks
0
Comment
Question by:Svgmassive
  • 2
3 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 1000 total points (awarded by participants)
ID: 41852735
just divide the value by 1,000,000,000  ( 1 billion)
0
 
LVL 27

Assisted Solution

by:Shaun Kline
Shaun Kline earned 1000 total points (awarded by participants)
ID: 41852863
A kilobyte is 1024 bytes.
A megabyte is 1024 kilobytes.
A gigabyte is 1024 megabytes.

Divide your number by 1024 * 1024 * 1024, or 1,073,741,824 for an exact amount. To get an approximate value, use Rey's answer.
0
 
LVL 27

Expert Comment

by:Shaun Kline
ID: 41880254
Both provided solutions answer the question asked.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Quickbooks hosting can do wonders to your enterprise but considering the points elaborated in the article which will help you to better analyze the outcomes. So scan your business, its needs and then move to the new world of limitless benefits.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question