Function Eval(c)
Application.Volatile
Eval = Evaluate("=" & c) '---> evaluate that string
End Function
to je tacno 1.2 (1).xlsx | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | 1-e | 175+175+88+175 | 613 | ||
2 | e-1 | 1070+835+301+329 | 2535 | ||
3 | e-t | 175+175+921+135 | 1406 | ||
4 | t-e | 1070+329+428+267 | 2094 | ||
5 | t-2 | 175+921+135 | 1231 | ||
6 | 2-t | 1070+428+428+267 | 2193 | ||
7 | e-I | 175 | 175 | ||
8 | I-e | 835 | 835 | ||
9 | I-a | 175 | 175 | ||
10 | a-I | 835 | 835 | ||
11 | a-3 | 175 | 175 | ||
12 | 3-a | 835 | 835 | ||
13 | 1-r | 123+88+105+88+221+35+140+158 | 958 | ||
14 | r-1 | 1227+148+364+247+170+90 | 2246 | ||
15 | r-n | 123+105+88+428 | 744 | ||
16 | n-r | 1227+221+921 | 2369 | ||
17 | n-4 | 123+428 | 551 | ||
18 | 4-n | 1227+921 | 2148 | ||
19 | e-b | 88+428+267 | 783 | ||
20 | b-e | 301+135 | 436 | ||
21 | b-5 | 88+428 | 516 | ||
22 | 5-b | 301+135 | 436 | ||
23 | r-l | 88+140 | 228 | ||
24 | l-r | 148+170 | 318 | ||
25 | l-ć | 88+140+267 | 495 | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
C1:C25 | C1 | =eval(B1) |