Thread: [Solved] I'm struggling to figure out how to do this
View Single Post
 
Old 04-07-2022, 07:30 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,943
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default
Quote:
Originally Posted by croberts View Post
Unfortunately I am unable to upload an Excel file today.

Let's say the Columns are Date, Deposit, and Balance. Deposit in col B is when you make an additional deposit. Balance in col C is showing you the balance. So if there are headers in row 1, then your data would start in row 2.

Here's the formula for the balance starting in C2: =C1+B1+1

Column B is in pence since you are adding 1 pence per day in col C.

Where does this answer come from? is the OP PM'ing you?
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote