In Google Documents, how can I convert a number according to a range?
Comments
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
£
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Still loading...
ABCDEF
1
http://www.techrepublic.com/blog/google-in-the-enterprise/the-truth-about-seven-persistent-google-docs-myths/
2
DescriptionScoreGroupsFrequencySub ScoreTotal Score
3
if score is (0-5) result should be 134531105
4
if score is (6-9) result should be 29932
5
if score is (10-15) result should be 3181543
6
if score is (16-21) result should be 4112144
7
if score is (22-26) result should be 5102655
8
if score is (27-31) result should be 6133166
9
if score is (32-36) result should be 713617
10
100
11
2618
12
8
13
3116
14
26
15
2614
16
31
17
2512
18
21
19
5
20
0
21
31
22
30
23
18
24
19
25
7
26
28
27
24
28
31
Loading...
 
 
 
Sheet1
Sheet3
Sheet4