Forum Discussion
louash07
Jul 17, 2021Copper Contributor
Binomial distribution
I keep getting an error when I try to drag the formula down to other cells to distribute the information.
Riny_van_Eekelen
Jul 17, 2021Platinum Contributor
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)