Welcome to ConvertPlus!

Thank you for choosing to install the ConvertPlus add-on for Google Sheets! Please read the following quick-start designed to get you up and running as fast as possible.

Viewing this Quick Start Message

Clicking "Add-ons" > "ConvertPlus" > "Quick Start" will allow you to re-view this quick-start message at any time.

What is ConvertPlus Exactly?

ConvertPlus extends the built in Google Sheets function "CONVERT" which allows conversion of one quantity (number with a unit of measure) to another unit of measure. ConvertPlus extends this function by adding:

  1. More units
  2. Explicit pre-fixes that can be added to any unit (e.g. [m]m, [c]m, [k]m)
  3. Ability to use compond units (e.g. "mi/hr" "k[g] m / s^2")
  4. Functions for adding, subtracting, multiplying, dividing, raising power of and comparing equality of quantities
  5. Ability to chain together all functions to avoid multiple cell calculations

Basic Unit Conversion

QCONVERT and QCONVERT2 are the direct equivalents of Google Sheets CONVERT, these functions perform unit conversions on a physical quantity from one unit of measure to another. The difference between the two flavors of this function is in how input is provided.

Example:

A B C D E
1 10 ft --> =QCONVERT(A1:B1, E1) in
2 20 degC --> =QCONVERT2(A2, B2, "degF") degF

↓

A B C D E
1 10 ft --> 120 in
2 20 degC --> 68 degF

You can see that QCONVERT takes the input quantity as a 2 cell range and QCONVERT2 takes the input quantity as a separate magnitude and unit. Note that many of the functions supplied by ConvertPlus follow this convention, the standard version takes the quantity as an array and there is a second version that allows you to split the inputs. In most cases you should be using the standard version, as it is more versatile (as you will see soon).

Unit Prefixes

ConvertPlus allow the use of prefixes on all units (e.g. milli -> "m"), but for purposes of efficient computation, they must be put in brackets before the unit.

Example:

A B C D E
1 10 [k]m --> =QCONVERT(A1:B1, E1) [c]m

↓

A B C D E
1 10 [k]m --> 1000000 [c]m

Compound Units

Compound units can be created with any combination of units, powers denoted with the carrot ( "^" ) and a numerator and denominator using the backslash ( "/" ). For instance the unit "ohm" could be expressed in SI base units using "[k]g m^2 / A^2 sec^3".

Example:

A B C D E
1 1000 [k]m / hr --> =QCONVERT(A1:B1, E1) mi / min

↓

A B C D E
1 1000 [k]m / hr --> 10.35618654 mi / min

Operations on Quantities

Operation can be performed on quantities to get a resulting quantity in the correct units. The following operation functions are available.

  1. QADD, QADD2 --> Add
  2. QSUB, QSUB2 --> Subtract
  3. QMUL, QMUL2 --> Multiply
  4. QDIV, QDIV2 --> Dividie
  5. QPOW, QPOW2 --> Raise to an integer power
  6. QEQ, QEQ2 --> Check for equality

Example:

A B C D E F
1 10 [k]m 20 league =QADD(A1:B1, C1:D1)
2 1 mi 1.61 [k]m =QSUB(A2:B2, C2:D2)
3 1 ha 1 [m]m =QMUL(A3:B3, C3:D3)
4 100 m 20 sec =QDIV(A4:B4, C4:D4)
5 10 [c]m =QPOW(A5:B5, C5:D5)
6 1 [k]m 0.62137 mi =QEQ(A6:B6, C6:D6)

↓

A B C D E F
1 10 [k]m 20 league 121.12 [k]m
2 1 mi 1.61 [k]m -0.000408 mi
3 1 ha 1 [m]m 10 m^3
4 100 m 20 sec 5 m / sec
5 10 [c]m 0.01 m^2
6 1 [k]m 0.62137 mi TRUE

Chaining Functions Together

Sometimes it is very useful to chain functions together, and this is possible with all of the standard functions (e.g. QADD). The second version (e.g. QADD2) can be chained but only if they are the innermost function. One reason you may want to chain functions is if an operation does not output to your prefered units and you would like to convert back. Another reason might be that you have to do more than one operation to get the result you want such as calculating power dissipation in a circuit using "V^2 / R" (Voltage squared over resistance).

Example:

A B C D E F
1 1 acre 1 ft =QMUL(A1:B1,C1:D1)
2 1 acre 1 ft =QCONVERT(QMUL(A2:B2, C2:D2), F2) acre ft
3 120 V 240 ohm =QCONVERT(QMUL(QPOW(A3:B3, 2), C3:D3), F3) W

↓

A B C D E F
1 1 acre 1 ft 1233.486771 m^3
2 1 acre 1 ft 1 acre ft
3 120 V 240 ohm 60 W

Available Units

A full list of available units, along with a short description of each one can be generated from the main add-on menu.

"Add-ons" > "ConvertPlus" > "Reference"

Pick a sheet name where you would like to generate the reference sheet and click "OK". This will generate the reference sheet.

Subscription

A free 30 day trial is supplied with this add-on, durring this time you will have full access to all functions. Afterwards this period ends and if you would like to continue using ConvertPlus, you can subscribe by clicking:

"Add-ons" > "ConvertPlus" > "Subscription"

This will open a sidebar that will allow you to directly enter a credit card and select a payment plan. Your subscription can be cancelled at any time by pressing the button labeled "Cancel Subscription" or by selecting "No subscription" as your payment plan.