AdamSalam
New Member
- Joined
- Mar 10, 2018
- Messages
- 15
I have one special case, I want to increase some values (deduction from a fixed value), that's the number will be subtracted each time increase the value in question.
For example I want to increase any number from 45 - 49 to 50, from a balance of 10. so If I increase 46 to 50 I still have only the value of 6 ...
I f I increased another number of the same series, say from 44 up to 50, I have no more values to use.
Another criteria is that I want to start from the GREATER numbers and go down to less values, for example If I have three numbers of 43 , 45, and 48 I start increasing the number 48 then 45 then 43 as long as I still have balance from the limited 10 value
I tried to use SUMIFS function but I couldn't figure out how to control all of that specially how to decrease the value of 10.
please find the sample data with some clarification included within the worksheet
as well as I paste it here in case the attachment didn't work
All values below 46 need to be upgraded 50 Max
All values in a row can be increased by 10 total
we start increasing the greater number and then the next until we reach a total 10 points
term1 mid yr term2
55 65 66
42 53 34
31 31 42
54 45 42
hope I could clear the situation so I get your help
thank you in advance
For example I want to increase any number from 45 - 49 to 50, from a balance of 10. so If I increase 46 to 50 I still have only the value of 6 ...
I f I increased another number of the same series, say from 44 up to 50, I have no more values to use.
Another criteria is that I want to start from the GREATER numbers and go down to less values, for example If I have three numbers of 43 , 45, and 48 I start increasing the number 48 then 45 then 43 as long as I still have balance from the limited 10 value
I tried to use SUMIFS function but I couldn't figure out how to control all of that specially how to decrease the value of 10.
please find the sample data with some clarification included within the worksheet
as well as I paste it here in case the attachment didn't work
All values below 46 need to be upgraded 50 Max
All values in a row can be increased by 10 total
we start increasing the greater number and then the next until we reach a total 10 points
term1 mid yr term2
55 65 66
42 53 34
31 31 42
54 45 42
hope I could clear the situation so I get your help
thank you in advance