# Software

## Question

Locked

### Excel Formulas

By ·
Hi Guys,

Do not know if I can ask this here

I want to try and do a spread sheet for my retirement. Say I have 20 years left to work and I want to have \$100 000 the day I retire. I want to be able to have a sheet where I can see that I am say in the 10th year and that by this time I should have saved 50 000 for my retirement. It must then show this to me in a value of between 1 - 10 in this case it would be 5 as I am halve way there.

I then also want to make a sheet where it show the following
Say my debt is a \$1000 dollar a week

I must work every week to pay this amount
This will be calculated over 10 weeks.
If I work 10 weeks I must have \$1000 in the bank to make sure I can pay the \$1000
If I only worked 9 out of the 10 week I must have \$2000 in the bank to ensure that I will be able to pay for the week that I did not work. So I want to ensure that I always have enough money in the bank to be able to pay my debts if I do not work. So if I only worked 3 out of the 10 weeks I must have \$7000 in the bank to be able to survive.
I will input every week if I worked or not
This must also then tell me where I am on a scale of 1 -10
10 being that I worked all 10 weeks and is good
1 being I only worked 1 week and need to ensure there is \$9000 in the bank to be able to pay everything. Basically 1 will tell me I am in trouble and 10 that I am good (same for the 1st sheet)

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)
| Thread display: Collapse - | Expand +

2 total posts (Page 1 of 1)

## Related Discussions

• 9

#### How can I open my photos

dazyparker123 //

• 3

#### what is the best image viewer for Windows 10?

newminionphowz //

• 0

m0andino //

• 2