Compute percentages
 

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

Compute percentages
 

hi,

=CEILING(B1/A1,0.1)

isabelle

Le 2013-10-30 17:36, GWC a écrit :
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

Compute percentages
 

On 30/10/2013 21:36, 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


With some difficulty since most of them are ~ 9%

--
Regards,
Martin Brown