We'd like to remind Forumites to please avoid political debate on the Forum... Read More »
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
Enjoying Life's Indulgences Together Everyday
Comments
-
What is this life if, full of care, we have no time to stand and stare0
-
Evening all
Lovely to see you Dr KReally 2 years since you were telling us you'd graduated?! Are you still in Manchester or back in Wales now?
nannylala, I grew up near Cambridge, and because it was local, the "family" supported Cambridge....... I however, opted to support Oxford, simply because I could
I remember the graduation....!
God I have been on here too long!:p:p:p:p
100 -
I d like to do all that but I've forgotten how to do spreadsheets so it s not a very good start
It's actually quite easy.
I can break it down.
Imagine one has £50,000.00 in a 5% savings account.
In one cell (let's call it A1), you would enter £50,000.00. In the next cell (A2), you would enter 5%. In the following cell (A3), you would enter =A1*A2. Now cell A3 will display the annual interest you earn for that £50,000 (which is £2,500.00). To work out the average monthly interest (let's call this cell A4), you would use the following formula =A3/12 (where 12 is the number of months per year). And the final cell (A5), could work out the final amount you earn following tax deduction every month...so the formula would be =A4*0.8 or =A4*0.6 (depending on whether you're a basic or high rate tax payer).:grouphug:Official MSE canny forumite and HUKD VIP badge member
:grouphug:
0 -
Careful on those steps E:)To do is to be. Rousseau
To be is to do. Sartre
Do be do be do. Sinatra0 -
Evening all
Lovely to see you Dr KReally 2 years since you were telling us you'd graduated?! Are you still in Manchester or back in Wales now?
nannylala, I grew up near Cambridge, and because it was local, the "family" supported Cambridge....... I however, opted to support Oxford, simply because I could
Still around Manchester.
Good to hear from you mid.:grouphug:Official MSE canny forumite and HUKD VIP badge member
:grouphug:
0 -
0
-
TrulyMadly wrote: »Talking of Easter....any glitches on eggs:)
I wouldn't know it's Panto season here.0 -
It's actually quite easy.
I can break it down.
Imagine one has £50,000.00 in a 5% savings account.
In one cell (let's call it A1), you would enter £50,000.00. In the next cell (A2), you would enter 5%. In the following cell (A3), you would enter =A1*A2. Now cell A3 will display the annual interest you earn for that £50,000 (which is £2,500.00). To work out the average monthly interest (let's call this cell A4), you would use the following formula =A3/12 (where 12 is the number of months per year). And the final cell (A5), could work out the final amount you earn following tax deduction every month...so the formula would be =A4*0.8 or =A4*0.6 (depending on whether you're a basic or high rate tax payer).
Yes thank you Karly that's about as clear as mud :rotfl:. I only learned how to use computers about 10 years ago when I went to some classes where I learned most things but since I don t do these things on a regular basis I ve forgotten how to to them0
This discussion has been closed.
Confirm your email address to Create Threads and Reply

Categories
- All Categories
- 351.6K Banking & Borrowing
- 253.4K Reduce Debt & Boost Income
- 453.9K Spending & Discounts
- 244.6K Work, Benefits & Business
- 600K Mortgages, Homes & Bills
- 177.2K Life & Family
- 258.3K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.2K Discuss & Feedback
- 37.6K Read-Only Boards