| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
bank account
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
bank account
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 --- Message posted from http://www.ExcelForum.com/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
bank account
Thanks,
I will go and try it now what service thanks again Pikus Writes 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 --- Message posted from http://www.ExcelForum.com/ |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
bank account
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) "nospam" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
bank account
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Linear Mode
