bank account

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

just a quick question, I hope!

I have set up a grid to balance my cheque book and it all works but I
have a formatting question

How do I stop the balances (270) from repeating if there is no content
in the cell to the left?

I.e. there is a value for insurance, 40, so I want the new balance, 460
to display but I don't want to display the 270s below beer as there is
no item listed after that, at the moment but there will be when I write
a cheque..

Opening Bal. 1000
mortgage 500 500
Insurance 40 460
food 30 430
car ins 30 400
ISP 10 390
petrol 20 370
bill 50 320
beer 50 270
270
270
270
270
270

Thanks
 
In the column with your totals, we'll call it column 'J' 'cuz that's the
first letter in my name, and well start in row 13 'cuz that's my
favorite number:

=IF(I13<>"",J14-I13,"")

-Pikus
 
Conditional formatting, formula of (e.g) =A10=A9 and set the font colour to
white

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top