Binomial distribution

Occasional Visitor

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

2 Replies

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

 

 

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