Lois_E begins a long MFW journey

nattypants

I'm fully caught up Lois, although feel a little bereft as I have enjoyed reading your diary so much:T

As I said in an earlier post, a lot of your diary resonated with me as I am also lucky enough to be in my forever home, work in education and although much, much older now I have two (one of each:D) children. Oh, and I also have a pulley (aka kitchen - or Sheila - maid in my utility room). I inherited this from the previous owner however currently don't use however as a part needs to be replaced.
I am seriously impressed with your savings/building work/MOPs balancing talent;)

Looking forward to your next post:D

Lois_E

Thanks natty. What a wonderful encouragement. Now I'll have to try to keep posting on here even when term starts again on Monday.

The good news is that today I have not spent any money today. The bad news is that that's because I didn't make time to go to the post office, which I should have done.

gallygirl

Lois have tried your formula and it doesn't work, it's changing every cell bright green . Any suggestions?

Thanks

GG x

Lois_E

Oh Bum. It works on my machine.

Can you give me some actual numbers in some actual cells, and tell me exactly what formula you typed in, please?

gallygirl

Lois you are a genius and I love you :kisses3:.

Now I've looked at the formula it's so simple really........

for you obviously, I haven't a scooby doo :rotfl:.

Lois_E

My pleasure gally.
Do ask again if you come across something else you want Excel to do.

gallygirl

Lois_E wrote: »

My pleasure gally.
Do ask again if you come across something else you want Excel to do.

Can you get it show a 0 balance before 1/9/16 please

Lois_E

gallygirl wrote: »

Can you get it show a 0 balance before 1/9/16 please

Easy!
Put 1/9/16 into cell Q1.
Now, your totals are in column G and your dates are in column B.
The formula in G3 currently says =C3+D3-F3
Replace this with =IF(B3>=$Q$1,0,C3+D3-F3)
Drag that down the whole of column G
Now it will automatically show as 0 on and after 1/9/16

What's that? Oh, you mean you don't just want Excel to show a 0 balance, you actually want to have a 0 balance? Hmm, that might be a bit more difficult. :cool:

Lois_E

Today's good news is that I still haven't spent any money.

Today's bad news is that that's because I still haven't made time to go to the post office.

Lois_E

I think I need to post a list on here to commit myself to getting stuff done today. I have already frittered away the morning without achieving anything significant.

So, today I will
1) [STRIKE]Catch up on laundry[/STRIKE]
2) Tidy my desk :eek:
3) Make kids write thank you letters Some progress made
4) Pack rucksack ready for work on Monday Done apart from finding my photocopy card
5) Make kids tidy downstairs Quite a lot of progress made but scope for more improvement
6) Research children's savings accounts and make decision
7) Spend some time playing with DD Done some of this but not as much as I intended