Forum Discussion

louash07's avatar
louash07
Copper Contributor
Jul 17, 2021

Binomial distribution

I keep getting an error when I try to drag the formula down to other cells to distribute the information.

excel

2 Replies

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Jul 17, 2021

    louash07 

    Instead of

    =BINOM.VERT(D13;B14;B12;0)

    Add dollar signs in the fixed cells / values and pull them down 

    =BINOM.VERT(D13;$B$14;$B$12;0)

     

    Example inserted into your file

     

    I would be happy to know if I could help.

     

    Nikolino

    I know I don't know anything (Socrates)

     

    * Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Jul 17, 2021

    louash07 You need to make the references to B12 and B14 absolute (i.e. put dollar signs in front of both the column and row number), like so:

    =BINOM.DIST(D13,$B$14,$B$12,0)

     

     

Resources