Calculate a Daily Balance from Income and Expenses in WPS Spreadsheets
Question details
The user needs to calculate the daily balance in column F by subtracting daily expenses in column D from daily income in column C.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user has a worksheet with daily income in column C and daily expenses in column D and wants a daily balance in column F for each row.
- Observed behavior
- The daily balance is not yet calculated; the expected result is the correct balance for each day based on the income and expense columns.
Open your worksheet in WPS Spreadsheets and confirm that income is in column C and expenses are in column D. If your data has headers, the first daily balance is usually entered in row 2.
Calculate the Daily Balance in Column F Using a Subtraction Formula
Use this method when income is in column C, expenses are in column D, and you want each day's balance in column F.
The formula subtracts the expense value from the income value for each row. When the layout is consistent, you can copy the formula down column F instead of typing it for every day.
Click cell F2 in WPS Spreadsheets, or select the first data row in column F where the daily balance should appear.
Type =C2-D2 in cell F2 and press Enter. This subtracts the expense in D2 from the income in C2.
Select cell F2 again, then drag the fill handle at the bottom-right corner of the cell down through the remaining rows in column F to apply the formula to each day.
Track Daily Balances in WPS Spreadsheets with a Simple Formula
Calculate a daily balance in WPS Spreadsheets by entering =C2-D2 in column F and filling the formula down. WPS Office works with Excel files and gives you the same spreadsheet functions for free.
- 1. Open your workbook in WPS Spreadsheets: Launch WPS Office and open the worksheet that contains daily income in column C and daily expenses in column D.
- 2. Select the first balance cell: Click cell F2 or the first row in column F where the daily balance should be calculated.
- 3. Enter the balance formula: Type =C2-D2 and press Enter to subtract the expense from the income for that row.
- 4. Copy the formula down column F: Drag the fill handle from the selected cell down through the remaining rows to calculate the balance for each day.
Frequently Asked Questions
What formula should I use to calculate a daily balance from income and expenses?
Use =C2-D2 in the first balance cell, such as F2, if daily income is in column C and daily expenses are in column D. Then fill the formula down column F.
Can I use this formula in WPS Spreadsheets if my file was created in Microsoft Excel?
Yes. WPS Spreadsheets opens .xlsx and .xls files, and formulas such as =C2-D2 work the same way.
How do I fill the formula down column F without typing it for each row?
Select the cell with the formula, then drag the fill handle at the bottom-right corner down through the remaining cells in column F.
What should I do if my expenses are already entered as negative numbers?
Use =C2+D2 instead. This adds the negative expense to the income and still produces the correct daily balance.
