I'm not sure if this is possible, however I am trying to sum a row, but if the sum value drops below a 0 it should just be 0. If it's a positive, it should return the value of the row. =IF(A3="","",SUM(B3:C3))+D2 It's a daily continuing total so I just added the day before to the next day if that make sense.
I have tried it a couple of ways but I can't get it to work.
I have tried it a couple of ways but I can't get it to work.
A | B | C | D | |
1 | Date | Credits | Roll Off | Total |
2 | 01/01/20 | 0.50 | -1.00 | -0.50 |
3 | 01/02/20 | 1.00 | -0.25 | 0.25 |
4 | 01/03/20 | 1.00 | -0.50 | 0.75 |
5 | 01/04/20 | 1.00 | -0.25 | 1.50 |