I have an excel sheet that I need assistance with. It has three columns : Deposits, Withdrawals, Receipt Number.
I need a formula that when there is a withdrawal from the account it is a reciept number. Each month would start at 0. The formula needs to leave a blank in the column if it is a deposit but one a withdrawal is shown it will locate the previous total and add 1 to it.
Example :
Deposit (blank) Withdrawal = $10 Reciept # =1
Deposit $10 Withdrawal (blank) Reciept (blank)
Deposit (blank) Withdrawl =$30 Reciept #=2
Sorrt about the example, it would not let me set it up like a table.
Thanks everyone for your help.
I need a formula that when there is a withdrawal from the account it is a reciept number. Each month would start at 0. The formula needs to leave a blank in the column if it is a deposit but one a withdrawal is shown it will locate the previous total and add 1 to it.
Example :
Deposit (blank) Withdrawal = $10 Reciept # =1
Deposit $10 Withdrawal (blank) Reciept (blank)
Deposit (blank) Withdrawl =$30 Reciept #=2
Sorrt about the example, it would not let me set it up like a table.
Thanks everyone for your help.