×
×לי
Hi all!
I am asking your help to solve a problem.
I have a general table consisted of 4 columns, and I want to change value in
a cell in one column if a combination of another 2 cells in the same row is
true.
My table looks like that:
A B C D
Capacity Capacity fix Cycle_Num Step_Num
1 10 1
1
2 20 1
1
3 30 1
1
4 40 1
2
5 50 1
2
6 60 1
2
7 70 1
2
1 10 2
1
2 20 2
1
3 30 2
1
4 40 2
2
5 50 2
2
6 60 2
2
7 70 2
2
and my question is: is it possible to change all the 'Capacity' values with
specific "Cycle_Num" and "Step_Num" indexes (for example Cycle_Num = 2 and
Step_Num = 1 ) if the first 'Capacity' value in this range is for example
higher then 2?
Thanks in advance
Eli
I am asking your help to solve a problem.
I have a general table consisted of 4 columns, and I want to change value in
a cell in one column if a combination of another 2 cells in the same row is
true.
My table looks like that:
A B C D
Capacity Capacity fix Cycle_Num Step_Num
1 10 1
1
2 20 1
1
3 30 1
1
4 40 1
2
5 50 1
2
6 60 1
2
7 70 1
2
1 10 2
1
2 20 2
1
3 30 2
1
4 40 2
2
5 50 2
2
6 60 2
2
7 70 2
2
and my question is: is it possible to change all the 'Capacity' values with
specific "Cycle_Num" and "Step_Num" indexes (for example Cycle_Num = 2 and
Step_Num = 1 ) if the first 'Capacity' value in this range is for example
higher then 2?
Thanks in advance
Eli