jb
Member
Sorry helpers,
I think I failed in explaining my problem. Sorry once again for that. Now I am uploading a file.
Look at 2nd, 4th and 6th row with title original, adjustment and final.
Original titled row shows actual data. Adjustment row B4 to G4 shows values to be added in B2 to G2 so that total of adjustment should not exceed 16.
Final row B6 to G6 is total of Original and Adjustment. Here B6 to G6 have values in almost same range.
This adjustment is valid because
B2 i.e. 12 getting 2 resulting in 14 , 7 is getting 6 resulting in 13. Here original value is 12 and 7 so final value of 12 should not be less than final value of 7.
B2 i.e. 12 getting 2 resulting in 14 , 13 is getting 2 resulting in 15. Here original value is 12 and 13 so final value of 12 should not be more than final value of 13.
12 and 13 are very near values so their final value can be equal.
Row 9, 11 and 13 shows example of wrong adjustment.
12+3 = 15, 13+1 = 14, 11+2=13
12 is smaller than 13 so its final value can not be 15.
Formula needed for adjustment row.
Note that the right adjustment shown in this example is for explanation purpose.
Other combination which follow the rule is acceptable.
I think I failed in explaining my problem. Sorry once again for that. Now I am uploading a file.
Look at 2nd, 4th and 6th row with title original, adjustment and final.
Original titled row shows actual data. Adjustment row B4 to G4 shows values to be added in B2 to G2 so that total of adjustment should not exceed 16.
Final row B6 to G6 is total of Original and Adjustment. Here B6 to G6 have values in almost same range.
This adjustment is valid because
B2 i.e. 12 getting 2 resulting in 14 , 7 is getting 6 resulting in 13. Here original value is 12 and 7 so final value of 12 should not be less than final value of 7.
B2 i.e. 12 getting 2 resulting in 14 , 13 is getting 2 resulting in 15. Here original value is 12 and 13 so final value of 12 should not be more than final value of 13.
12 and 13 are very near values so their final value can be equal.
Row 9, 11 and 13 shows example of wrong adjustment.
12+3 = 15, 13+1 = 14, 11+2=13
12 is smaller than 13 so its final value can not be 15.
Formula needed for adjustment row.
Note that the right adjustment shown in this example is for explanation purpose.
Other combination which follow the rule is acceptable.
Last edited:
