How do I make a formula for precentages?

D

doddlebugger

I have a number of miles to be surveyed and each day I will keep track of
these miles I want a formula to calculate the precent of miles surveyed.
 
S

Steve H.

Total Miles to Survey in A1
Total Miles Surveyed in A2
=A2/A1 in A3


Format A# as percent
 
B

BenjieLop

doddlebugger said:
I have a number of miles to be surveyed and each day I will keep trac
of
these miles I want a formula to calculate the precent of mile
surveyed.
Click to expand...

If I undertand your post ...

Column A (start with A2) is where you enter number of miles surveyed o
a daily basis. For this exercise, let us assume that your column A wil
extend up to A30.

Enter this formula in B2: =sum($A$2:A2) and copy down until B30.

Enter this formula in C2: =B2/"total miles" and copy down until C30.

NOTE: The denominator, "total miles", is a constant. This number is th
total miles that need to be surveyed.

Hope this helps
 
G

Gord Dibben

Assuming your miles to be surveyed in D2

Assuming daily miles entered in column A starting in A2

In B2 enter =IF(A2="","",A2/$E$2) to return daily percentage.
Drag/copy down column A

In C2 enter =IF(A2="","",SUM($A$2:A2)/$E$2) to return a running total.
Drag/copy down Column B

Note the dollar($) signs. These must be left as is.

Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Secondary axis alignment 0
help w indirect and index,match 3
Average formula 4
Excel Countif Function - Calculating Between Two Sets of Values 3
VB Script reference cells for in current table? 1
In Excel, how do I display a leading zero? e.g. 05 for 5 ? 1
How do I 2
Overwriting a cell with a formula without deleting the formula 1

Top