Format (click to use) | Preview |
---|---|
decimal | |
percent | |
fraction | |
money | |
scientific | |
engineering | |
tape measure | |
fraction over 16 | |
hex | |
bin | |
oct | |
dec | |
round | |
roundup | |
rounddown | |
value (no units) | |
unit (single unit) | |
no format |
|
||
Arithmetic+ - * x /
|
2 + 2 - 3 (3 * 5) / 2 |
1 7.5 |
Roots/powers | sqrt(9) 5^2 |
3 25 |
Percent | 5% 17% of 200 17% off 200 20 + 50% |
0.05 34 166 30 |
Modulo / remainder | 5 mod 3 | 2 |
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 1000 as sci |
1,234 0.001 1e3 |
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 Conversion Commands | ||
Convert units (in, to, into, as, -> ):
15 feet into inches = 180 inches Unit rates ( / , per, every, until) 15 miles/hour into feet/second = 22 feet/second 15 pounds per year in pounds per month = 1.25 pounds/month Custom units (rates, plurals) 15 sales/day in minutes per sale = 96 minutes/sale 15 sales/day in minutes until 5 sales = 480 minutes/5 sales Autoconversion ( @ , at, using, with, for) 15 mph @ 10 hours = 150 miles 15 mph @ 100 miles = 6.667 hours 150 dollars/sale @ 10 sales/day @ 10 days = 15,0000 dollars 150 dollars/sale @ 10 sales/day @ 750 dollars = 0.5 day Implied Conversion 15 mph in min = 0.25 miles/min 15 mph in /min = 0.25 miles/min 15 mph in km = 24.1 km/hour |
Unit Support | ||
SI Unit Support SI units and prefixes (m, s, kg, newton, Pa, kWh...) 10 N -> base = 10 kg m/s^2 (SI base unit) 10 kg m/s^2 = 10 newton (automatically simplified) |
||
Weight:
oz, lb, g, kg, ug (microgram), ton 150 lbs in kg = 68.038 kg |
||
Length:
mile, yard (yd), foot (ft), inch (in), m, cm, km 15 feet in inches = 180 inches |
||
Area (square, ^2):
acre, square mile, yd^2, in^2, cm^2 2 acres in m^2 = 8093.712 m^2 |
||
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 cubic inches |
||
Time:
second (s/sec), minute (min), hour (hr), day, month, year 3 days in minutes = 4320 minutes |
||
Currency (3-letter code):
USD, EUR, JPY, CAD, MXN, GBP... 15 USD in EUR = 12.69... EUR (updated weekly) |
||
Stock price lookup: STOCK(symbol)
STOCK(AAPL) = 210.53 (last closing price) |
||
Construction / Tape Measure
3' 4" x 2 = 6' 8" 180 cm as tape measure = 5' 10 55/64" |
Formatting | ||
Currency formatting | $5 $5 / 3 |
$5.00 $1.67 |
Add comment (text to ignore) |
30 + 40 // new total | 70 new total |
Expand/collapse row | Click result to toggle row |
|
Insert/remove row | Hover row label ("R1") to display row options | |
Row display format (as, to, into,
-> )
|
||
0x123 as decimal | 291 | |
.15 as percent | 15% | |
.15 as fraction | 3/20 | |
15000 as money | 15K | |
15000 as scientific | 1.5e4 | |
15000 as engineering | 15e3 | |
3.5 inches as tape measure | 3 1/2" | |
100 as hex | 0x0064 | |
100 as bin | 0b01100100 | |
100 cm as value | 100 | |
100 cm as unit | 1 cm | |
100 cm as tape measure | 3' 3 3⁄8" |
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 |
Scientific (Trig & 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 | 1,500,000 (as bits/sec) |
Time |
time(90) time(1gb / 1.5mbps) |
1m 30.00s 1h 31m 1.333s |
Base Conversion | ||
Into decimal | 0b1001 as decimal 0o567 as dec 0xfeff as dec |
9 375 65,279 |
From decimal | 9 as binary oct(375) hex(65,279) |
0b00001001 0o567 0xfeff |
Programming | ||
Assignment shorthand | x = 3 ++x x += 3 |
3 4 7 |
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 (two's complement) |
Logical operators (> >= == <= <) |
2 * 2 > 3 x == 3 2 * 2 > x |
true true true |
Conditional Statements | ||
Simple if/else statement if (3 > 2) { "bigger" } else { "smaller or equal" } Multiple conditions: and (&&), or (||) if (temp > 75 and weather == "sunny") { "go to beach" } if (temp < 0 or weather=="snowing" ) { "cold" } else { "not cold" } if (x > 3 && x < 20) {"in range"} else {"out of range"} Using nested if statements if (score >= 90) { "A" } else if (score >= 80) { "B" } else if (score >= 70) { "C" } else { "F" } if (mileage > 10000 && months > 12) { "overdue" } else if (mileage > 5000 || months > 6) { "service soon" } else { "recently serviced" } |
Date/Time | ||
now | current date and time | |
today | current day (also: tomorrow, yesterday) | |
1/1/90 | specific date (M/D/Y) | |
date(1990, 1, 1) | make date function (Y, M, D) | |
1/1/90 + 200 days | Fri, Jul 20, 1990 | |
8pm PST in EST | 11pm EDT (timezone conversion) | |
Dec 31 - today | Days between now and end of year | |
3h 15m | 3h 15m (timespan) | |
3:15 | 3h 15m (hh:mm) | |
00:3:15 | 3m 15s (hh:mm:ss) |
Excel Financial Functions | ||
Loan payment | PMT(rate, nper, pv, [fv (optional)], [type]) | |
Interest payment | IPMT(rate, per, nper, pv, [fv (optional)], [type]) | |
Principal payment | PPMT(rate, per, nper, pv, [fv (optional)], [type]) | |
Interest payment (specific period) | ISPMT(rate, per, nper, pv) | |
Present value | PV(rate, nper, pmt, [fv (optional)], [type]) | |
Future value | FV(rate, nper, pmt, [pv (optional)], [type]) | |
Internal rate of return | IRR(values, [guess (optional)]) | |
Net present value | NPV(rate, r1:r5) or NPV(rate, val1, val2...) | |
Interest rate per period (annuity) | RATE(nper, pmt, pv, [fv (optional)], [type], [guess]) | |
Number of periods (annuity) | NPER(rate, pmt, pv, [fv (optional)], [type]) | |
Interest rate per period (annuity) | RRI(nper, pv, fv) | |
Number of periods (annuity) | PDURATION(rate, pv, fv) |
Excel Statistical Functions | ||
Variance (var) | var(r1:r3) or var(x, y, ...) | |
Standard deviation | stddev(r1:r3) or stddev(x, y, ...) | |
Range | range(r1:r3) or range(x, y, ...) | |
Count | count(r1:r3) or count(x, y, ...) | |
Mean/median/mode | mean(r1:r3) or mean(x, y, ...) | |
Percentile | percentile(r1:r3, p) or percentile(x, y, ..., p) | |
Combination | combin(n, k) or combination(n, k) | |
Permutation | permut(n, k) or permutation(n, k) |
Power User Features | ||
Calc import/export | Docs | |
Object/arrays | Docs | |
Load remote JSON data | Docs | |
Import calc into another | Docs | |
Comment string interpolation | Docs | |
Excel-style functions | Docs | |
Insert Greek letters | Docs | |
Function calls and custom formats | Docs | |
Suggest a feature on the forum |
Format (click to use) | Preview |
---|---|
decimal | |
percent | |
fraction | |
money | |
scientific | |
engineering | |
tape measure | |
fraction over 16 | |
hex | |
bin | |
oct | |
dec | |
round | |
roundup | |
rounddown | |
value (no units) | |
unit (single unit) | |
no format |
Calc simplicity meets spreadsheet power. Get handy results on-the-fly using natural language, unit
conversions, variables, and even programming — without files, installs, or waiting. Share a
calculator link without a login.
Loving a calculator just might be
possible.
Loving a calculator just might be possible.
The perfect calc/spreadsheet hybrid. Loving a calculator just might be possible.
Variable | Current | Solution value |
---|
Scratchpad