Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Less than, Greater than Formula | Excel Discussion (Misc queries) | |||
Help with SUMIF, INDEX, LOOKUP Please !! | Excel Worksheet Functions | |||
Help w/ SUMIF ; INDEX | Excel Worksheet Functions | |||
If Greater than when a formula Results in N/A | Excel Worksheet Functions | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel |