How to convert bytes to KB and MB in Excel?

In Excel, to convert “bytes” from a cell D2 to KB/MB in a cell C2, insert the following to a cell C2:

=IF(D2>=1048576,D2/1000000&" MB",IF(AND(D2<1048576,D2>1024),D2/1000&" KB",D2&" BYTES"))

And then copy the formula down by dragging the bottom right-hand corner of the cell with the formula to the end of your KB/MB info already entered.

Leave a Reply

Your email address will not be published. Required fields are marked *