View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben[_2_] Gord Dibben[_2_] is offline
external usenet poster
 
Posts: 621
Default 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