Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copying into excel from a online bank account | Excel Discussion (Misc queries) | |||
how to account the number of cells which is bank and written? | Excel Discussion (Misc queries) | |||
I want to put a bank account number that begins with 00 in Excel. | Excel Worksheet Functions | |||
Any templates for personal bank account tracking? | New Users to Excel | |||
What is the formula for bank account row balance column | Excel Worksheet Functions |