<div>
Final part to convert to GB, rest all as Kevin explained.
</div>


Final part to convert to GB, rest all as Kevin explained.

<div>
Mr.zorvek (Kevin Jones),<br />
<br />
Thank You For Replying.<br />
<br />

<blockquote>
The final part is to divide the total by 1024^3 which converts KB to TB.<br />

</blockquote>
<br />
Final Result Is &quot;6.366716&quot; By Applying This Formula. So It Is 6.366716 TB? I Guess It Is 6.366716 GB.<br />
<br />
Thanks
</div>


Mr.zorvek (Kevin Jones),

Thank You For Replying.



> The final part is to divide the total by 1024^3 which converts KB to TB.


Final Result Is "6.366716" By Applying This Formula. So It Is 6.366716 TB? I Guess It Is 6.366716 GB.

Thanks

<div>
Yes, I believe you are correct.<br />
<br />
Kevin
</div>


<div>
Opps I dint Refresh The Browser Before Posting.<br />
<br />
Thanks
</div>


Opps I dint Refresh The Browser Before Posting.

Thanks

<div>
Awesome New Thing Learned !!!
</div>


<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
<br />
Just need to know how This &nbsp;formula works. what is the logic behind this.<br />
<br />
Column A <br />
50MB<br />
60 KB<br />
6.1 GB<br />
60KB<br />
223MB<br />
<br />
<br />
Formula in B1<br />

<pre><code id="code-8259683">=SUMPRODUCT(LEFT(A1:A5,LEN(A1:A5)-2)*1024^(MATCH(LEFT(RIGHT(A1:A5,2)),{&quot;K&quot;,&quot;M&quot;,&quot;G&quot;,&quot;T&quot;},0)))/1024^3</code></pre>
<br />
<br />
Thank you
</div>
</div>


Hi Experts,


Just need to know how This  formula works. what is the logic behind this.

Column A 
50MB
60 KB
6.1 GB
60KB
223MB


Formula in B1



Thank you

Formula Explanation

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

An office suite is a collection of bundled productivity software (a software suite) intended to be used by knowledge workers. The components are generally distributed together, have a consistent user interface and usually can interact with each other, sometimes in ways that the operating system would not normally allow. Most contain a word processor, a spreadsheet, an email client and presentation software; some might contain a database program. Several office suites have their own topics: Microsoft Office, Office 365, LibreOffice (also known as OpenOffice), Lotus IBM and Google Apps.