View original (French)

Calculation of a margin of error

Solved
Lillinoute83 Posted messages 54 Registration date   Status Membre Last intervention   -  
Lillinoute83 Posted messages 54 Registration date   Status Membre Last intervention   -
Hello everyone,

In column A: the number of visits to be made
In column B: the number of visits made
I need to put in column C, as a %, my margin of error compared to column A which is 10%
then in column D, I need to indicate my actual margin of error in %.

2 réponses

Réponse 1 / 2
Yoyo01000 Posted messages 1720 Registration date   Status Membre Last intervention   168
 
Hello,
in column C: =10%*$A2
in column D: =$B2/$A2
cell format in column D: Percentage
0