|
Unit Conversions
Convert units (to, into, per, /):
15 feet into inches = 180
Weight: oz, lb, g, kg, mg, ug (microgram), ton
150 lbs in kg = 68.038
Mix & match, custom:
15 miles/hour into feet/second = 22
15 pounds/year in pounds/month = 1.25
15 sales/day in minutes per sale = 96 Length: mile, yard (yd), foot (ft), inch (in), knot, span, league, km, m, cm, mm, nm, pm
15 feet in inches = 180 Area (square, ^2): acre, square mile, yd^2, in^2, cm^2
2 acres in m^2 = 8093.712 Volume (cubic, ^3): gallon (gal), quart (qt), pint (pt), cup (cp), fl oz, tbsp, tsp, cubic inch, ft^3, L, mL, cm^3, cc
1500 cc in cubic inches = 91.53
| Time: second (sec), minute (min), hour (hr), day, month, year, decade, century, ms, us, ns, ps
3 days in minutes = 4320 Currency (3-letter code): USD, CAD, AUD, CNY, EUR, JPY, BRL, GBP, IRL, CNY, MXN, HKD...
15 USD in EUR = 12.69... (updated weekly)
Stock price lookup: STOCK(symbol)
STOCK(AAPL) = 210.53 (most recent close)
|
|
| Rounding |
Arithmetic
+ - * / | 2 + 2 - 3
(3 * 5) / 2 | 1
7.5 | | Roots & powers | sqrt(9)
5^2 | 3
25 | | Percent | 5%
100 * 17%
20 + 50% | 0.05
17
30 | Number shortcuts
(k, m, b, t) | 3.3k
200 million
6.6b | 3,300
200,000,000
6,600,000,000 | | Scientific notation | 1.234e3
1e-3 | 1,234
0.001 | | Variables & Rows | | Using variables | x = 9
y = x + 3
| 9
12
| | Using rows | r1
r2
r3
sum(r1:r3)
average(r1:r3)
max(r1:r3)
min(r1:r3) | 9
12
3
24
8
12
3 | | Unit Conversions | Convert units (to, into, per, /):
15 feet into inches = 180
Mix & match, custom:
15 miles/hour into feet/second = 22
15 pounds/year in pounds/month = 1.25
15 sales/day in minutes per sale = 96
| Weight: oz, lb, g, kg, mg, ug (microgram), ton
150 lbs in kg = 68.038 | Length: mile, yard (yd), foot (ft), inch (in), knot, span, league, km, m, cm, mm, nm, pm
15 feet in inches = 180 | Area (square, ^2): acre, square mile, yd^2, in^2, cm^2
2 acres in m^2 = 8093.712 | Volume (cubic, ^3): gallon (gal), quart (qt), pint (pt), cup (cp), fl oz, tbsp, tsp, cubic inch, ft^3, L, mL, cm^3, cc
1500 cc in cubic inches = 91.53 | Time: second (sec), minute (min), hour (hr), day, month, year, decade, century, ms, us, ns, ps
3 days in minutes = 4320 | Currency (3-letter code): USD, CAD, AUD, CNY, EUR, JPY, BRL, GBP, IRL, CNY, MXN, HKD...
15 USD in EUR = 12.69... (updated weekly) | Stock price lookup: STOCK(symbol)
STOCK(AAPL) = 210.53 (most recent close) | | 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 | | Expand/collapse row | Click result to toggle row
| | Insert/remove row | Hover row label ("R1") to display row options | | Other Number Commands | | Random numbers | random
random(10) | 0.434...
7 | | Rounding | round(3.51)
roundup(3.01)
rounddown(3.99) | 4
4
3 | | Absolute value | abs(-2) | 2 | | Factorial | 3! | 6 | | Trigonometry & Logarithms | | Constants | PI
E | 3.14159...
2.71828... | | Radians (default degrees) | 30
30 deg
PI rad | 30
30
180 | sin, cos, tan
sinh, asin, etc. | sin(30)
sin(PI/4 rad) | 0.5
0.707... | e^x, ln, log
| exp(2)
E^2
ln(2)
log(2) // base 10
log_2(8) | 7.389...
7.389...
0.693...
0.301...
3
| | Computer Units | File sizes (bytes)
(kb, mb, gb, tb, pb) | 1kb
10 gb / 5mb
| 1024
2048 | Bandwidth (bits/sec)
(kbps, mpbs, gbps) | 1.5 mbps | 196,608 | Time
| time(90)
time(1gb / 1.5mbps) | 1m 30.00s
1h 31m 1.333s | | Base Conversion | | Into decimal | 0b1001 (binary)
0o567 (octal)
0xfeff (hex) | 9
375
65,279 | | From decimal | bin(9)
oct(375)
hex(65,279) | 0b00001001
0o567
0xfeff | | Programming | Binary operators
(and or xor not) | bin(a = 3)
bin(b = 5)
a and b
bin(a and b)
a or b
a xor b
not a | 0b00000011
0b00000101
1
0b00000001
7
6
-4 | Logical operators
(> >= == <= <) | 2 * 2 > 3
x == 3
2 * 2 > x
| true
true
true | | Conditional statements | if (3 > 2){"bigger"} else {"smaller or equal"} | bigger | | Shorthand | x = 3
++x
x += 3 | 3
4
7 |
|
|
|