Ajjan M
asked on
converting mb to tb
Hello, I have 3 cells each one of the cells receives certain amount of numbers in MB, GB, and TB. I want to create another cell to sum all the entries in these cells as a total and give the answer in TB. I appreciate your help.
You can't put a formula in TB without overwriting the value that is there. Also what row applies?
Suppose you have MB amount in cell A1, GB amount in cell A2, and TB amount in cell A3.
The sum will be in A4 and the formula will be: =A1/1000000+A2/1000+A3
that will be corrent since 1TB = 1000000 MB, and 1TB = 1000GB.
Hote that helps'
Zvitam.
The sum will be in A4 and the formula will be: =A1/1000000+A2/1000+A3
that will be corrent since 1TB = 1000000 MB, and 1TB = 1000GB.
Hote that helps'
Zvitam.
ASKER
I'm afraid I didn't get your question well. what do you mean by overwriting the value? I added a screen shot of sample to what I asked it might look easier than writing the question.
Screen-Shot-2018-03-13-at-11.39.09.png
Screen-Shot-2018-03-13-at-11.39.09.png
I thought MB etc was Column References.
You cannot sum those values because they are not numbers - they contain text.
Attach the workbook and I'll amen it so that the sum will work.
You cannot sum those values because they are not numbers - they contain text.
Attach the workbook and I'll amen it so that the sum will work.
ASKER
I uploaded the workbook.
Book1.xlsx
Book1.xlsx
There are some solutions to adding mixed kb mb & gb values here
I've added Custom NumberFormats so you enter numbers and the letters appear. This will not affect the sum formula because it is formatting not actual letters.
This article might help you understand
Book1--4-.xlsx
This article might help you understand
Book1--4-.xlsx
You can just sum the values you have to divide it as I state in my comment earlier.
zvitam
You cannot sum those entries because they contain text!
You cannot sum those entries because they contain text!
And strictly speaking, it is not a direct 1,000 factoring.
1MB = 1024KB,
1GB = 1024MB,
1TB = 1024GB
However, the publicly recognised factoring is 1000
1MB = 1024KB,
1GB = 1024MB,
1TB = 1024GB
However, the publicly recognised factoring is 1000
Roy cox: You can since that text is part of the cell custom format, and not the cell value.
Following Rob Henson good comment I correct what I wrote earlier:
The sum will be in A4 and the formula will be: =A1/1048576+A2/1024+A3
that will be corrent since 1TB = 1048576 MB, and 1TB =1024GB.
Following Rob Henson good comment I correct what I wrote earlier:
The sum will be in A4 and the formula will be: =A1/1048576+A2/1024+A3
that will be corrent since 1TB = 1048576 MB, and 1TB =1024GB.
It isn't in the original workbook, I added Custom NumberFormats
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
@Rob Hensen, it is giving me "there is a problem with this formula"
Probably the brackets, I will have a look.
As I thought, there was an extra bracket at the end, try this:
=SUM(LEFT(C3,SEARCH("B",C3 ,1)-2)/104 8576,LEFT( D3,SEARCH( "B",D3,1)- 2)/1024,LE FT(E3,SEAR CH("B",E3, 1)-2)*1)
=SUM(LEFT(C3,SEARCH("B",C3
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Covers author's requirement