View original (French)

Calculation of a margin of error

Solved
Lillinoute83 Posted messages 54 Registration date   Status Member Last intervention   -  
Lillinoute83 Posted messages 54 Registration date   Status Member 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 answers

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