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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Greater Than Symbols and calculations 0
Formula Greater than Less Than 4
Sumif number is greater than a number but less than another number 2
Nested Greater than or less than Formula 4
Greater Than and less than HELP PLEASE 4
Greater than Less than formula 2
Greater than Less than formula 3
Multiple conditions using greater than or less than. 1

Back
Top