ExcelBanter - Compute percentage

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Compute percentage (https://www.excelbanter.com/excel-programming/449439-compute-percentage.html)

gwc

Compute percentage

How can I divide B by A and get 10%?

A B

1 0.34 0.03
2 0.34 0.03
3 0.68 0.06
4 0.67 0.06
5 0.67 0.06
6 0.67 0.06
7 0.78 0.07
8 0.89 0.08
9 0.33 0.03
10 0.66 0.06
11 0.66 0.06

Gord Dibben[_2_]

Compute percentage

=ROUND(B1/A1,1) enter in C1 then copy down.

Gord

On Wed, 30 Oct 2013 14:38:35 -0700 (PDT), GWC
wrote:

How can I divide B by A and get 10%?

A B

1 0.34 0.03
2 0.34 0.03
3 0.68 0.06
4 0.67 0.06
5 0.67 0.06
6 0.67 0.06
7 0.78 0.07
8 0.89 0.08
9 0.33 0.03
10 0.66 0.06
11 0.66 0.06

All times are GMT +1. The time now is 09:03 AM.