P
pytelium
I have a spreadshhet with 3 columns,I wish to create a fourth column
which
carries out an action,if 2 conditions are met.
col a has value that is greater than 6
col c value is the appropriate value for the range in which values
of b fall.
col b contains numbers in the range 1 to 1000.
The categories in col b and appropriate values in col c are shown
below.
If the values in col c are greater than the correct values I want no
action taken,in col d.
col b col c
1 to 2 0.01
2.02 to 3 0.02
3.05 to 4 0.05
4.1 to 6 0.1
6.2 to 10 0.2
10.5 to 20 0.5
21 to 30 1
32 to 50 2
55 to 100 5
110 to 1000 10
an example sheet
A B C D
6.3 3.2 .05
2.58 4.6 0.4
0.24 4.2 0.3
0.43 10 13
4.14 21 11.5
0.64 17.5 51.5
0.26 17 63
0.82 24 84
1.00 27 113
0.90 23 116
0.38 38 132
1.29 26 142
0.90 26 264
0.38 26 234
0.75 32 388
0.94 32 118
here only the 1st row fulfils the 2 conditions.
which
carries out an action,if 2 conditions are met.
col a has value that is greater than 6
col c value is the appropriate value for the range in which values
of b fall.
col b contains numbers in the range 1 to 1000.
The categories in col b and appropriate values in col c are shown
below.
If the values in col c are greater than the correct values I want no
action taken,in col d.
col b col c
1 to 2 0.01
2.02 to 3 0.02
3.05 to 4 0.05
4.1 to 6 0.1
6.2 to 10 0.2
10.5 to 20 0.5
21 to 30 1
32 to 50 2
55 to 100 5
110 to 1000 10
an example sheet
A B C D
6.3 3.2 .05
2.58 4.6 0.4
0.24 4.2 0.3
0.43 10 13
4.14 21 11.5
0.64 17.5 51.5
0.26 17 63
0.82 24 84
1.00 27 113
0.90 23 116
0.38 38 132
1.29 26 142
0.90 26 264
0.38 26 234
0.75 32 388
0.94 32 118
here only the 1st row fulfils the 2 conditions.