I'm having trouble with a greater than,Less than formula
 

I an trying to carry a total from one day to the next on a running
inventory.It is possible that at the end of a day to have a negative balance.
When I carry it over to the next day I need the negative total to revert to a
zero.I've tried the "if" that works but the need is for a 0 in place of the
true in less than and the sum of the cells in place of the false.

Thank you

Hi Donna,

If the day total is in (say) cell A100, try:

= MAX(A100,0)


---
Regards,
Norman



"Donna" wrote in message
...
I an trying to carry a total from one day to the next on a running
inventory.It is possible that at the end of a day to have a negative
balance.
When I carry it over to the next day I need the negative total to revert
to a
zero.I've tried the "if" that works but the need is for a 0 in place of
the
true in less than and the sum of the cells in place of the false.

Thank you

=if(lastmonthsbalance<0,0,sum(A1:A100))

"Donna" wrote:

I an trying to carry a total from one day to the next on a running
inventory.It is possible that at the end of a day to have a negative balance.
When I carry it over to the next day I need the negative total to revert to a
zero.I've tried the "if" that works but the need is for a 0 in place of the
true in less than and the sum of the cells in place of the false.

Thank you