![]() The formula for this, for the second entry, reads =IF(A4="","",G3+(E4-F4)) if you're setting the spreadsheet up to track expenses, and it reads =IF(A4="","", G3+(F4-E4)) if you're setting the spreadsheet up to show cash on hand. If you want to keep the cell with the balance empty until a complete entry has been made, you can use an IF statement in the formula so that if a date hasn't been entered, the balance cell won't display a value.The parentheses around the cells representing the difference between expenses and revenue aren't necessary they're included just to make the formula concept a bit clearer.If you're setting the spreadsheet up to keep a running tab on your cash on hand, the balance formula would be =G3+(F4-E4). ![]() ![]()
0 Comments
Leave a Reply. |