Article in English: Insert a formula into column K that does the math to calculate the running balance. Note that you did not need a formula in cell K2. This is where you entered your opening balance.  Click on cell K3. Now click on the formula bar at the top of the spreadsheet. This is where you will type in the formula that tells the cells to perform a calculation. Type the formula =SUM(K2-F3+H3). This tells the spreadsheet to take our opening balance (cell K2), and subtract a debit if one exists (cell F3) and add a credit if one exists (cell H3).  Suppose your opening balance was $200, and your first entry was a check you wrote for $35.00. The $35.00 is recorded as a debit in cell F3. The formula you entered in cell H3 takes the opening balance and subtracts the debit, leaving you with a balance of $165.00. Select cell K3. Right-click and select “Copy.” Select cells K4 and K5. Right-click and select “Paste.” The formula is now copied into these cells. You should see that the running balance has been calculated in column K for all the rows of test data that you entered. You could copy the above formula into cell K6. But since you haven’t entered any data in this row, the running balance from cell K5 will also appear in cell K6. To clean this up, create a conditional formula that leaves the cell blank if no transactions have been entered, but displays a balance if they have been entered. In cell K6, enter the formula =IF(ISBLANK(B6),"",SUM(K5-F6+H6)). This tells Excel that if cell B6, in the “DATE” column, is blank, then cell H6 should be blank. But if cell B6 is not blank, then the balance should be calculated. The AutoFill automatically fills in formulas in adjacent cells so you won’t have to enter the “BALANCE” formula over and over again.  Find the AutoFill handle in the active cell. Observe the small, dark square in the bottom right corner of the active cell. Hover over it and the cursor will change to the AutoFill cursor, which looks like a thin plus sign.  Click on cell K6. Hover over the AutoFill handle and the cursor...

Summary in Indonesian:
Ciptakan formula untuk menghitung saldo berjalan. Salin formulanya. Buat formula kondisional untuk membersihkan kolom saldo berjalan. Perluas formula dengan AutoFill.