|
|
||
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) | |
| Charts | ||
| Bar chart | BARCHART(R1:R3)
|
|
| Line chart | LINECHART(R1:R3)
|
|
| Pie chart | PIECHART(R1:R3)
|
|
| 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 | |
| Imaginary and complex numbers | Docs | |
| Suggest a feature on the forum | ||
Calc Options
Theme Options
Shareable mini spreadsheets.
Share/Embed
without a login.
Tired of clunky spreadsheets? Get results on-the-fly using natural language, unit
conversions, currencies, even programming — without files or app installs. Share a
link in seconds.
Loving a calculator just might be
possible.
- Instant answers using natural language (250k + 10%)
- Share or embed a live, interactive calculator (no login)
- Variables, currencies, unit conversions, programming, and more (tour)
Loving a calculator just might be possible.
The perfect calc/spreadsheet hybrid. Loving a calculator just might be possible.
Use arithmetic (+ - * /) and friendly names like 250k or 50 million.
Answers appear as fast as you can type them.
Calcs can be shared or embedded with 1 click, like these examples.
Put a comment on any row using:
// comment text
Show/hide a row by clicking the red result
Supports international characters and yes, even emoji (Excel's too uptight for that.)
Weight ounce (oz), pound (lb), ton gram (g), kilogram (kg), milligram (mg), microgram (ug)
Length mile, yard (yd), foot (ft), inch (in), knot, span, league kilometer (km), meter (m), cm, mm, nm, pm
Area (add "square", "sq" or "^2" to any unit): sq in, in^2, square meter, cm^2, acre
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, in^3, Liter (L), milliliter (mL), imperial gallon, imperial pint.
Temperature Celsius (C), Fahrenheit (F), Kelvin (K), Rankine (R)
Time second (sec), minute (min), hour (hr), day, month, year, decade, century, millisecond (ms), microsecond (us), nanosecond (ns), picosecond (ps)
Data (case insensitive, gb=gigabyte, gbit=gigabit): bit, byte, kilobit, kilobyte, KB, MB, GB, TB, PB, EB
Currency (3-letter code) USD (US Dollar), EUR (Euro), JPY (Yen), CAD (Canadian dollar), GBP (British Pound), IRL (Indian Rupee), CNY (Chinese Yuan)
[unit] [to/in/into] [unit]
[unit][per][unit] in [unit][per][unit]
Fancy unit conversions
[units][per][unit] to [units][per][# units]
[units][per][unit] to [units][until][# units]
Use arithmetic with dates and timespans (+ -)
Specify and convert timezones (current timezone by default)
1234 (decimal)
0o1234 (octal)
0x1234 (hex)
0b10101 (binary)
hex(x) converts to hex
bin, oct, dec
logical operators and or not xor
bin(0b01 or 0b10)
if(condition) {x = 1} else {x = 2}
multiple statements: x = 1; y = 2; z = 3;
Constants: PI, E, PHI
sin, cos, tan, asin, acos, atan, sinh, cosh, tanh
Degrees by default
Radians via
sin(x
rad)
1.123e10
x^y
x^(1/y)
sqrt(x)
x^(-y)
ln(x), exp(x)
log(x), 10^x
Factorial: 3!
Absolute value: abs(x)
A few more exotic commands.
random = [0.00 ... 1.00]
random(5) = [1 ... 5]
random(10) = [1 ... 10]
round, roundup, rounddown
Row operations
SUM(R1:R3)
AVERAGE(R1:R3)
MIN(R1:R3)
MAX(R1:R3)