# Thread: calculations

1. Registered User
Join Date
Sep 2002
Location
USA
Posts
76

## Unanswered: calculations

Greetings,

The goal is to walk/run either 3 miles per day or 40 miles bi-weekly (20 miles per week).
I’ve attached the sample worksheet I created and would like to modify it as follows:

1.When I enter the # of miles each day and it is <3 miles, let’s say 2 miles, then I would like to display a text saying “…almost you’re short by a mile to meet your goal..”

2. The next day if # of miles = 3, then I would like a message saying “great, you meet your goal today…”
3. If # of mile run >3, let’s say 5 miles, then the txt message would read “ excellent, you’ve exceeded your daily goal by 2 miles)

The same message for bi-weekly (bi-weekly #1 a mile short, and bi-weekly #2 exceeded the 40 miles goal by 5 miles)

Thank you in advance,
OCM

2. Registered User
Join Date
Oct 2002
Location
Baghdad, Iraq
Posts
697
What you're doing, effectively, is creating a balance sheet. You don't even need macros for this.

Column A contains the date, as a regular Excel date. Column B is the running total of your goal, that is B2 = B1 + 3. Column C is how many miles you ran/walked that day. Column D is a running total of that, D2 = D1 + C2. Column E is the difference between what you achieved and your goal, E2 = D2 - C2.

Adding the extra formatting makes it look prettier, but if it's just for your personal use, who cares?

Oh, and try to mix up your runs a little rather than always doing 3 miles. Especially plyometrics and sprints every now and then are good to improve your form; good form is important because it helps lessen damage to joints and prevents shin splints.

3. Registered User
Join Date
Sep 2002
Location
USA
Posts
76

## calculation

sco08y, thanks for your reply post. I'll try your method and post back if I've any question.

OCM

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•