|
|
||
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 | ||
Meet Calcy! Ask for "retirement plan" or "vacation budget" and Calcy will cook up a custom calculator for you.
He can even improve existing calcs.
Do not take medical advice from Calcy.
Calc Options
Theme Options
Colors
Font
Size
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.