Copyright © 2010 Yonah Russ' Journal. All Rights Reserved. Snowblind by Themes by bavotasan.com. Powered by WordPress.
Posts Tagged ‘ excel ’
Here is a great tip for formatting numbers in Excel as Gigabytes, Megabytes, Kilobytes, Bytes, etc.
Use the following formula:
=IF((A1>=POWER(2,30)),
TEXT((A1/POWER(2,30)),”##0.00\G”),
IF((A1>=POWER(2,20)),
TEXT((A1/POWER(2,20)),”##0.00\M”),
IF((A1>=1024),
…









Recent Comments