使用说明: (更多使用指南在博客中)
|
输入 |
示例 |
运算结果 |
|
算术+ - * /
|
2 + 2 - 3
(3 * 5) / 2 |
1
7.5 |
|
平方根和乘方 |
sqrt(9)
5^2
|
3
25 |
|
百分数 |
5%
100 * 17%
20 + 50%
|
0.05
17
30
|
|
简短数值(k, m, b, t) |
3.3k
200 million (or 200m)
6.6 billion (or 6.6b)
|
3,300
200,000,000
6,600,000,000
|
|
科学计数法 |
1.234e3
1e-3 |
1,234
0.001 |
|
变量与行 |
|
使用变量 |
x = 9
y = x + 3
sqrt(x)
x + y |
9
12
3
21 |
|
使用行 |
r1
r2
r3
sum(r1:r3)
average(r1:r3) |
9
12
3
24
8 |
|
单位转换 |
转换单位为其他单位 ():
15 feet into inches = 180
也可转换速度单位:
15 miles/hour into feet/second = 22
15 pounds/year in pounds/month = 1.25
/, per, until, every
|
重量:
ounce (oz), pound (lb), ton
gram (g), kilogram (kg), milligram (mg), microgram (ug)
150 lbs in kg =
|
长度:
mile, yard (yd), foot (ft), inch (in), knot, span, league
kilometer (km), meter (m), cm, mm, nm, pm
15 feet in inches =
|
面积 (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 =
|
体积 (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
=
|
时间
second (sec), minute (min), hour (hr), day, month, year, decade, century
millisecond (ms), microsecond (us), nanosecond (ns), picosecond (ps)
3 days in minutes =
|
汇率 (3-letter code)
USD (US Dollar), EUR (Euro), JPY (Yen), BRL (Brazilian Real), GPB (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 = (weekly
updates; general estimates only)
|
|
四舍五入 |
round(3.51)
roundup(3.01)
rounddown(3.99) |
4
4
3 |
|
绝对值 |
abs(-2) |
2 |
|
阶乘 |
3! |
6 |
|
输入格式
|
|
金融格式 |
$5
$5 / 3 |
$5.00
$1.67 |
|
添加注释(文本被忽略)
|
30 + 40 // new total |
70 |
|
隐藏行 |
Click result to hide row
|
Insert/remove row
(插入/移除行) |
Click "R1" to display row options
|
|
做图 |
|
使用行输入数据 |
bob = 18
joe = 27
jim = 31
|
18
27
31 |
Type: bacrchart, piechart, linechart
(类型:柱状图,饼图,折线图) |
barchart(r1:r3)
(Variable names become labels)
(变量名变成标记) |

Click for example
|
|
其他数字和命令 |
|
随机数 |
random
random(10) |
0.434...
7 |
|
四舍五入 |
round(3.51)
roundup(3.01)
rounddown(3.99) |
4
4
3 |
|
绝对值 |
abs(-2) |
2 |
|
阶乘 |
3! |
6 |
|
三角函数与对数指数 |
|
常量 |
PI
E |
3.14159...
2.71828...
|
度与弧度
(默认是度) |
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
Natural Log (ln)(自然对数)
Log base 10 (log)
|
exp(2)
E^2
ln(2)
log(2)
|
7.389...
7.389...
0.693..
0.301...
|
|
计算机用单位 |
文件大小 (bytes)
(kb, mb, gb, tb, pb) |
1kb
10 gb / 5mb
|
1024
2048 |
带宽 (bits/sec)
(kbps, mpbs, gbps) |
1.5 mbps |
196,608 |
时间
|
time(90)
time(1gb / 1.5mbps) |
1m 30.00s
1h 31m 1.333s
|
|
基本进制转换 |
|
转换为十进制 |
0b1001 (binary)
0o567 (octal)
0xfeff (hex)
|
9
375
65,279 |
|
从十进制转换为 |
bin(9)
oct(375)
hex(65,279) |
0b00001001
0o567
0xfeff
|
|
编程 |
|
二元运算符
(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 |
逻辑运算符
(> >= == <= <) |
2 * 2 > 3
x = 3
2 * 2 > x
|
true
3
true
|
|
条件语句 |
if (3 > 2){"bigger"} else {"smaller or equal"} |
bigger |
|
快速上手 |
x = 3
++x
x += 3
|
3
4
7 |
|