View Source

A

B

C

1

1

2

JOIN(A1:B2)

2

3

4

"sin(pi()/2)=" & sin(pi()/2)

3

NOW()

"sum(a1:b2)=" & sum(a1:b2)

Formula Settings

	A	B	C
1	1	2	JOIN(A1:B2)
2	3	4	"sin(pi()/2)=" & sin(pi()/2)
3	NOW()		"sum(a1:b2)=" & sum(a1:b2)