This formula works because digital units have a “power of 10” relationship.
are based on the metric system.
The formula below will normalize to binary units.
With this formula, you are technically getting Gibibytes (GiB), not Gigabytes.
MATCH supports approximate and exact matching, andwildcards(* ?)
For example, =LEFT(“apple”,3) returns “app”.
For example, =RIGHT(“apple”,3) returns “ple”.
