Binomial distribution

[louash07]

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

[#2]

@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)

[#3]

@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.