1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
|
Input Section
Input a number here> 20.02
range: number 1 54.00
range: number 2 7.77
range: number 3 8.00
range: number 4 6.05
range: number 5 87.00
range: number 6 54.01
----------------------------------------------------------
Date/Time Fncs
@now 809368284.0000000
@hour(B11) 11.0000000
@minute(B11) 31.0000000
@second(B11) 24.0000000
@month(B11) 8.0000000
@day(B11) 25.0000000
@year(B11) 1995.0000000
@dts(B15,B16,B17) 809326800.0000000
@tts(B12,B13,B14) 41484.0000000
{@date(B11)} Fri Aug 25 11:31:24 1995
Math Functions
@acos(@cos($C$1)) 1.1704441
@asin(@sin($C$1)) 1.1704441
@atan(@tan($C$1)) 1.1704441
@atan2($C$1,$C$2) 0.3550313
@ceil($C$1) 21.0000000
@cos($C$1) 0.3897428
@exp($C$1) 494966182.4914107
@abs($C$1) 20.0200000
@dtr($C$1) 0.3494149
@fabs($C$1) 20.0200000
@floor($C$1) 20.0000000
@hypot($C$1,$C$2) 57.5916695
@ln($C$1) 2.9967318
@log($C$1) 1.3014641
@max($C$1:$C$7) 87.0000000
@min($C$1:$C$7) 6.0500000
@nval(\"C\", 1) 20.0200000
@pi Lab:pi 3.1415927
@pow($C$1,3) 8024.0240080
@rnd($C$1) 20.0000000
@round($C$1,1) 20.0000000
@rtd($C$1) 1147.0615059
@sin($C$1) 0.9209238
@sqrt($C$1) 4.4743715
@tan($C$1) 2.3629015
Stat Functions
@sum($C$1:$C$7) 236.8500000
@avg($C$1:$C$7) 33.8357143
@prod($C$1:$C$7) 1910370676.8274128
@stddev($C$1:$C$7) 31.4903873
Other Range Functions
@count($C$1:$C$7) 7.0000000
|
