Show zero in this VALUE formula instead of negative number

Good Monring,

I have the following formula:

=VALUE(M11)-VALUE(N10)

it referes to the first cell in this row which is:

=23-VALUE(C10)

when a cell hits 23, the rest of the cells show a negative number, instead I would like those cells to show zeros.

Thank you

Hi Bebo,

thank you for your help,

i tried entering that formula and the rest of the cells shows a negative number once over 23.

Hi Bebo,

i want to make a correction to me reply, that formula did work in cell C11, but subsequest cells are fomulated to subtract the amounts in cells D10-N10 until they reach 23. When the reach 23 they show a negative number. Instead I will like them to show a zero.

Cell C11 has the formula:
=23-VALUE(C10).

Cell D11 and following cells have the formula:

=VALUE(C11)-VALUE(D10) Which takes the value of the prior cell and subtracts the cell above it until the number 23 is reached.

So in cell G11, it takes the value of cell F11 and then subtracts the amount in cell G10.

I have attache a sample to help with the visual.

Thank you

Thank you for your help and quick responses! Your solution works perfectly!