Edit formula

[MarkDShark]

I was given this code to use. but i need to edit it to not deduct the amounts i enter in E13:E17 for cell E10. I only want the entries in E13:E17 to affect cell E7. The formula below determines the lowest figure bewteen E7 and E10 and the lowest figure is what i'm trying to capture in another cell. The entries in E13:E17 should only pretain to E7 to lesson it upon an entry being made, example

I enter 14 in E7
I enter 12 in E10

12 is the lowest, so thats picked up in the target cell.

Same scenerio, but now i enter a figure between E13:E17, lets say 4, now this figure should affect the amount in E7 (not direrctly) and the target cell should now recognize E7 as the lowest figure of 10. How do i edit the formula below to do that? Thanks for your help in advance.

=MAX(CHOOSE(MIN(MATCH(MIN(G55:G59),G55:G59,0),2),E7,E10-E9)-SUM(E13:E17),0)

 

[DonkeyOte]

Obviously your formula incorporates other tests not detailed in the narrative but if you're saying E13:E17 should affect only E7 then you move that element accordingly

=MAX(CHOOSE(MIN(MATCH(MIN(G55:G59),G55:G59,0),2),E7-SUM(E13:E17),E10-E9),0)

It should be noted that E7 is only in use where G55 is in fact the smallest value in range G55:G59 (c/o CHOOSE)