# Percentage completed in column F

#### xeven_

##### Active Member
My spreadsheet has #'s 1-67 in column A. I want to put a formula in column F that will calculate the percentage of each row to 100%. What is the formula I can use?

 1 Homework Orientation % 2 Homework 1.1 Standard Notation % 3 Homework 1.2 Addition % 4 Homework 1.3 Subtraction 5 Homework 1.4 Multiplication 6 Homework 1.5 Division 7 Homework 1.6 Rounding, Estimating, and Order 8 Homework 1.7 Solving Equations 9 Homework 1.8 Applications & Prob Solving

<colgroup><col><col span="2"><col><col><col></colgroup><tbody>
</tbody>

### Excel Facts

To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
percentage of what ??

The percentage of that row from all of the rows used. In this case I have 67 rows filed in and the 67th row will represent 100%. So I want a formula that will calculate the preceding rows eg: 67 is 100%, 66 will be ?%. 65 ?%....

Is this what you mean? If not, more details please.

Formula in F2 copied down to the end of the numbers in column A.

Note that I've hidden most of my rows to keep the screen shot small.

Excel Workbook
ABCDEF
1Num%
211.49%
322.99%
434.48%
545.97%
657.46%
768.96%
8710.45%
9811.94%
626191.04%
636292.54%
646394.03%
656495.52%
666597.01%
676698.51%
6867100.00%
69
Percentage

Oh You are AWESOME!!!!
I wish you taught college classes on Excel only!
I love Australia always wanted to move there!

Thanks again Peter.

Replies
11
Views
1K
Replies
11
Views
1K
Replies
5
Views
516
Replies
9
Views
358
Replies
3
Views
236

1,203,026
Messages
6,053,116
Members
444,640
Latest member
Dramonzo

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back