•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Setting up a formula for a running deduction, ideally with total column staying blank until new deduction entered
The above screenshot shows a starting balance of £100 in cell G3. As I enter a value into column F, the adjacent cell in column G shows the new balance. I've set-up a simple subtraction formula for each cell in column G that deducts the value manually entered into a cell in column F from the value given in the preceding cell in G. However, all the cells in column G display the running balance.
I have 2 questions:
Is the simple subtraction formula used in each cell of column G appropriate?
Is there anyway the cells in column G only display a value when a value is manually entered into the adjacent cell in column F?
Thank you for your help.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#AI formula generation techniques
#generative AI for data analysis
#formula generator
#rows.com
#Excel compatibility
#Excel alternatives
#financial modeling with spreadsheets
#subtraction formula
#starting balance
#running balance
#manual entry
#Excel
#cell G3
#column F
#value deduction
#appropriate formula
#formula setup
#balance calculation