pwrCONVERTSTORAGE

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")

Leave a Reply

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