Increase a number depending on its value|VBA & Macros|Excel Forum|My Online Training Hub

Hi all, 

I have one special case, I want to increase some values (the value increased will be deducted from a fixed value 10), that's the value add will be subtracted each time a number in question increased.

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 ...

If 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.

hope I could clear the situation so I get your help

thank you in advance