,''' ''','''A''','''B''',
,'''0''', 1.00, 2.00,
,'''1''', 3.00, 4.00,
,'''2''', 5.00, 6.00,
EjemplosPlanilla22010-06-09 18:09:03TiN12010-06-09 18:08:18TiNEXAMPLE: 1.00 2.00 3.00
10.00 20.00 30.00
RESULT: 1.002.003.00
10.0020.0030.00
ABCD
1.00 2.00 3.00
RESULT: ABCD
1.002.003.00
1.00 2.00 3.00
10.00 20.00 30.00
11.00 22.00 33.00
RESULT: 1.002.003.00
10.0020.0030.00
11.0022.0033.00
ABC
1.00 2.00 3.00
10.00 20.00 30.00
11.00 22.00 33.00
RESULT: ABC
1.002.003.00
10.0020.0030.00
11.0022.0033.00
AB
1.00 2.00
3.00 4.00
5.00 6.00
RESULT: AB
1.002.00
3.004.00
5.006.00
0 1.00 2.00
1 3.00 4.00
2 5.00 6.00
RESULT: 01.002.00
13.004.00
25.006.00
AB
0 1.00 2.00
1 3.00 4.00
2 5.00 6.00
RESULT: AB
01.002.00
13.004.00
25.006.00
AB
0'm''p'
11a1 * 5
22a2-3
334
RESULT: AB
0mp
11=A1*5
22=A2-3
334
ABCDEF
Name Vorname 3.00 5.00
Name Vorname 1.00 2.00 4.00 5.00
Name Vorname 1.00 2.00 5.00
RESULT: ABCDEF
Name Vorname3.005.00
Name Vorname1.002.004.005.00
Name Vorname1.002.005.00
1.0 2.0
3.0 4.0
4.0 16.0
RESULT: 1.02.0
3.04.0
4.016.0
{{{ useage of variable names -show_formular -column_header -row_header }}} ABC
0'A''B''C'
112a1+two
21020sum('a2:b2')
3sum('a1:a2')sum('b1:b2')sum('c1:c2')
RESULT: ABC
0ABC
11{two}2=A1+two
21020=@sum(A2:B2)
3=@sum(A1:A2)=@sum(B1:B2)=@sum(C1:C2)
and if we calculate BR RESULT: ABC
0ABC
1 1.00 2.00 3.00
2 10.00 20.00 30.00
3 11.00 22.00 33.00
{{{color in cells }}} |
1.00 2.00 3.00
10.00 20.00 30.00
11.00 22.00 33.00
RESULT: ABC
1.002.003.00
10.0020.0030.00
11.0022.0033.00
{{{delimit input with ',' }}} AB
1.00 2.00
3.00 4.00
5.00 6.00
RESULT: AB
1.002.00
3.004.00
5.006.00
{{{delimit input and output with ',' }}} RESULT: