PowerUp Description
The pwrCONVERTSTORAGE PowerUp function converts a number with a given unit to an equivalent number in another unit. Many common units are included ranging from bits to yottabytes.
PowerUp Syntax
pwrCONVERTSTORAGE(value, SourceUnit, TargetUnit)
The pwrCONVERTSTORAGE PowerUp function has the following arguments:
value – Required. This is the number you will be converting.
SourceUnit – Required. This is a value that represents the source unit which are detailed below.
TargetUnit – Required. This is a value that represents the target unit to which the conversion will be done. Any combination of the argument values below can be used.
BIT – Bit
KBIT – Kilobit
MBIT – Megabit
GBIT – Gigabit
TBIT – Terabit
PBIT – Petabit
EBIT – Exabit
B – Byte — 8*bit
KB – Kilobyte — 1024 Bytes
MB – Megabyte — 1024 KB
GB – Gigabyte — 1024 MB
TB – Terabyte — 1024 GB
PB – Petabyte — 1024 TB
EB – Exabyte — 1024 PB
ZB – Zettabyte — 1024 EB
YB – Yottabyte — 1024 ZB
Return Value
pwrCONVERTSTORAGE will return an equivalent number of SourceUnit expressed in TargetUnit.
Remarks
For some of the very large or high precision numbers, the possibility for round off errors exists. Always verify the returned values.
Example
=pwrCONVERTSTORAGE(A1,"mbit","gb")
