Hello everyone,
Really struggling with a piece of work that hopefully one of you can kindly help with.
I am basically look for a type of count that will not jump up a whole number when it reaches .9. For example, I am looking for my count to go from;
5.8
5.9
5.10
5.11
5.12
Here is a sample of my data;
rank(L) count(M) Lookup(O)
1 1 1.1
2 1 2.1
3 1 3.1
4 1 4.1
5 11 5.1
6 0 5.2
7 0 5.3
8 0 5.4
9 0 5.5
10 0 5.6
11 0 5.7
12 0 5.8
13 0 5.9
14 0 6
15 0 6.1
16 1 16.1
17 1 17.1
18 1 18.1
my data is showing that there are 11 counts of "5", so therefore I require my "lookup" field formula to display 5.1 to 5.11. Instead it is displaying 5.1 to 6.1. The formula I am currently using is;
=(IF(M9>0,L9&"."&"1",O8+0.1))
Any suggestions or is what I am after not even possible?
Thanks
Gavin
Really struggling with a piece of work that hopefully one of you can kindly help with.
I am basically look for a type of count that will not jump up a whole number when it reaches .9. For example, I am looking for my count to go from;
5.8
5.9
5.10
5.11
5.12
Here is a sample of my data;
rank(L) count(M) Lookup(O)
1 1 1.1
2 1 2.1
3 1 3.1
4 1 4.1
5 11 5.1
6 0 5.2
7 0 5.3
8 0 5.4
9 0 5.5
10 0 5.6
11 0 5.7
12 0 5.8
13 0 5.9
14 0 6
15 0 6.1
16 1 16.1
17 1 17.1
18 1 18.1
my data is showing that there are 11 counts of "5", so therefore I require my "lookup" field formula to display 5.1 to 5.11. Instead it is displaying 5.1 to 6.1. The formula I am currently using is;
=(IF(M9>0,L9&"."&"1",O8+0.1))
Any suggestions or is what I am after not even possible?
Thanks
Gavin