Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I make a formula for precentages?
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. |
#2
|
|||
|
|||
Total Miles to Survey in A1
Total Miles Surveyed in A2 =A2/A1 in A3 Format A# as percent "doddlebugger" wrote in message ... 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. |
#3
|
|||
|
|||
doddlebugger Wrote: 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. If I undertand your post ... Column A (start with A2) is where you enter number of miles surveyed on a daily basis. For this exercise, let us assume that your column A will 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 the total miles that need to be surveyed. Hope this helps. -- BenjieLop ------------------------------------------------------------------------ BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019 View this thread: http://www.excelforum.com/showthread...hreadid=314075 |
#4
|
|||
|
|||
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 On Tue, 16 Nov 2004 14:34:01 -0800, doddlebugger wrote: 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. |
#5
|
|||
|
|||
Typo alert!
Assuming your miles to be surveyed in E2 Gord On Tue, 16 Nov 2004 16:54:35 -0800, Gord Dibben <gorddibbATshawDOTca wrote: 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 On Tue, 16 Nov 2004 14:34:01 -0800, doddlebugger wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to make formula grow with the table | Excel Discussion (Misc queries) | |||
how do i make a cell date sensitive to execute a formula or input. | Excel Discussion (Misc queries) | |||
how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
How to make a formula display results only if value is greater tha | Excel Discussion (Misc queries) | |||
How do I make an If-Then formula in Excel? | Excel Worksheet Functions |