Recent content by Max99000

I found a solution. The SUMIFS formula is not exactly what I needed. I used an IF statement combined with MAX formula. Example: To calculate I13 - =IF((G13+H12)<0,MAX(((I12+C13)+(G13+H12)),0),(I12+C13)) Thanks for the help guys!

What do you mean by ";"? The error says that I cannot use rotating variables.

OK. This should calculate "I4" considering the Account Balance: =IF((G4+H3)<0,(I3+C4)-(G4+H3),(G4+H3)) but it does not work.

Can anyone help me with the formula. I have no idea what to do. I have tried IF and SUMIF functions but I could not get it to work.

Can someone please help me find the right formula for this spreadsheet? I need to subtract from the "Savings Account" to make the "Current Account Bank Balance" 0 (ZERO) only IF the "Current Account Bank Balance" is negative, otherwise not. Also, if the negative balance of "Current Account Bank...