Hi,
I have values in column listed as following.
Is there any way to find if any value in column going less then the permissible limit?
For example:
I have a column A Which have variable data when making any changes effects values in column B
I want to set the constraint such that if column A making any values in Column B less than 6 (by increasing or decreasing value in column A ) then that value in column A will be rejected and Column A value will not update further (Increase or Decrease).
so the concept here is to loop through each Row in Column A and try to increase and decrease value until condition is satisfied.
Example 1:
<tbody>
</tbody>
at 100 -------- 7 Acceptable
at 50 ----------6.5 Unacceptable
so the final value would be 100
Example 2:
<tbody>
</tbody>
If I decrease from 150 to 125 the value somewhere in column B goes down from 7.5 to 5.5 which is not acceptable.
Therefore, 150 will be accepted.
at 150 -------7.5 Acceptable `
at 125 -------5.5 Unacceptable
so, the final value would be 150
Thanks![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
I have values in column listed as following.
Is there any way to find if any value in column going less then the permissible limit?
For example:
I have a column A Which have variable data when making any changes effects values in column B
I want to set the constraint such that if column A making any values in Column B less than 6 (by increasing or decreasing value in column A ) then that value in column A will be rejected and Column A value will not update further (Increase or Decrease).
so the concept here is to loop through each Row in Column A and try to increase and decrease value until condition is satisfied.
Example 1:
Column A | Column B |
120 | 15 |
100 | 12 |
100/50 | 7/6 |
<tbody>
</tbody>
at 100 -------- 7 Acceptable
at 50 ----------6.5 Unacceptable
so the final value would be 100
Example 2:
Column A | Column B |
520 | 15 |
400 | 12 |
350 | 11 |
200 | 10 |
150/125 | 10 |
8 | |
7.5/5.5 |
<tbody>
</tbody>
If I decrease from 150 to 125 the value somewhere in column B goes down from 7.5 to 5.5 which is not acceptable.
Therefore, 150 will be accepted.
at 150 -------7.5 Acceptable `
at 125 -------5.5 Unacceptable
so, the final value would be 150
Thanks