| Basic Commands (click section title for examples) | ||
| Feature | Example | Result |
| Arithmetic + - * / |
2 + 2 - 3 (3 * 5) / 2 |
1 7.5 |
| Roots & powers | sqrt(9) |
3 25 |
| Percent | 5% |
0.05 |
| Number shortcuts (k, m, b, t) |
3.3k |
3,300 |
| Exponent notation | 1.234e3 1e-3 |
1,234 0.001 |
| Variables & Rows | ||
| Using variables | x = 9 y = x + 3 sqrt(x) x + y |
9 12 3 21 |
| Using rows | r1 r2 r3 sum(r1:r3) average(r1:r3) |
9 12 3 24 8 |
| Unit Conversions | ||
| Convert unit into another (green means success): 15 feet into inches = 180 inches Can even convert rates: 15 miles/hour into feet/second = 22 feet/second 15 pounds/year in pounds/month = 1.25 pounds/month /, per, until, every | ||
|
Weight: ounce (oz), pound (lb), ton gram (g), kilogram (kg), milligram (mg), microgram (ug) 150 lbs in kg = 68.038...kg |
||
|
Length: mile, yard (yd), foot (ft), inch (in), knot, span, league kilometer (km), meter (m), cm, mm, nm, pm 15 feet in inches = 180 inches |
||
|
Area (add "square" or "^2" to any unit) acre, square mile, yd^2, in^2... km^2, square meter, cm^2... 2 acres in m^2 = 8093.712... m^2 |
||
|
Volume (add "cubic" or "^3" to any unit) gallon (gal), quart (qt), pint (pt), cup (cp), fluid ounce (fl oz), tablespoon (tbsp), teaspoon (tsp), cubic inch, ft^3... Liter (L), milliliter (mL), cm^3 (cc), cubic km... 1500 cc in cubic inches = 91.53... cubic inches |
||
|
Time second (sec), minute (min), hour (hr), day, month, year, decade, century millisecond (ms), microsecond (us), nanosecond (ns), picosecond (ps) 3 days in minutes = 4320 minutes |
||
|
Currency (3-letter code) USD (US Dollar), EUR (Euro), JPY (Yen), BRL (Brazilian Real), GBP (British Pound), IRL (Indian Rupee), CNY (Chinese Yuan), MXN (Mexican Peso), HKD (Hong Kong Dollar), AUD (Australian Dollar), CAD (Canadian Dollar)... 15 USD in EUR = 11.59... EUR (weekly updates; general estimates only) |
||
| Rounding/Formatting | ||
| Rounding | round(3.51) roundup(3.01) rounddown(3.99) |
4 4 3 |
| Absolute value | abs(-2) | 2 |
| Factorial | 3! | 6 |
| Formatting Cells | ||
| Currency formatting | $5 $5 / 3 |
$5.00 $1.67 |
| Add comment (text to ignore) |
30 + 40 // new total | 70 new total |
| Hide row | Click result to hide row
|
|
| Insert/remove row | Click "R1" to display row options
|
|
| Other Number Commands | ||
| Random numbers | random random(10) |
0.434... (from 0...1) 7 (from 1...10) |
| Rounding | round(3.51) roundup(3.01) rounddown(3.99) |
4 4 3 |
| Absolute value | abs(-2) | 2 |
| Factorial | 3! | 6 |
| Trig / Logarithms / Scientific | ||
| Constants | PI E |
3.14159... |
| Degrees & radians (degrees by default) |
30 30 deg PI rad |
30 30 180 |
| sin, cos, tan asin, acos, atan |
sin(30) sin(PI/4 rad) |
0.5 0.707... |
e^x |
exp(2) E^2 ln(2) log(2) |
7.389... 7.389... 0.693.. 0.301... |
| Computer Units | ||
| File sizes (bytes) (kb, mb, gb, tb, pb) |
1kb |
1024 2048 |
| Bandwidth (bits/sec) (kbps, mpbs, gbps) |
1.5 mbps | 196,608 (converted to bytes/sec) |
| Time |
time(90) time(1gb / 1.5mbps) |
1m 30.00s 1h 31m 1.333s |
| Base Conversion | ||
| Into decimal | 0b1001 (binary) |
9 375 65,279 |
| From decimal | bin(9) oct(375) hex(65,279) |
0b00001001 0o567 0xfeff |
| Programming | ||
Binary operators |
bin(a = 3) |
0b00000011 0b00000101 1 0b00000001 7 6 -4 (two's complement) |
| Logical operators (> >= == <= <) |
2 * 2 > 3 x = 3 2 * 2 > x |
true |
| Conditional statements | if (3 > 2){"bigger"} else {"not bigger"} | bigger |
| Excel IF | EIF(3 > 2, "bigger", "not bigger") | bigger |
| Shorthand | x = 3 |
3 4 7 |