Compute percentages

[GWC]

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

 

[isabelle]

hi,

=CEILING(B1/A1,0.1)

isabelle

Le 2013-10-30 17:36, GWC a écrit :

 

[Martin Brown]

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%