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:





Instead of


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



Example inserted into your file


I would be happy to know if I could help.



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.