Deducting value of cell w/out going negative

[KarmaTheDog]

Hello all,
I have a problem hopefully someone can help me with: I have a target cell that sums a range of cells, but I would like that cell to also deduct the value of another cell without the target cell going below zero- if that makes sense. Even if I have to use a look-cell; I just don't know the formula.

Thank you

 

[MrKowz]

Try something like:

=MAX(*your function*,0)

 

[VoG]

Try

=Min(90,your formula)

 

[KarmaTheDog]

I'm sorry if I seem like a novice but I don't understand how to implement your solutions. In this instance cell H21 sums H12:H19. I'd like H21 reflect a deduction of the value of cell G21 without H21 going negative. So H21 would sum the range of cells and then deduct the value of G21 until H21 hit zero.

 

[MrKowz]

Try:

=MAX(SUM(H12:H19)-G21,0)

Or are you wanting to subtract G21 over and over and over again until you hit zero, then show how much is remaining?

 

[KarmaTheDog]

Thank you MrKowz, your solution is exactly what I needed. Thanks for your help.