COMBIN formula problem!

[S.H.A.D.O.]

Good afternoon,

I am having trouble with the formula...

=COMBIN(L$4,C14)*COMBIN(L$5-L$4,0)*COMBIN(L$6,E14)*COMBIN(L$4,E14-1)

It returns a #NUM ! error.

Thanks in advance.

 

[DanteAmor]

You could put the values ​​you have in each cell L4, C14, L5, L6, E14

 

[S.H.A.D.O.]

Thanks for the reply DanteAmor,

You could put the values ​​you have in each cell L4, C14, L5, L6, E14

I have values in those cells which I want the formula to pick up and make the calculations on when I copy it down!

 

[DanteAmor]

I understand that, but I want to perform the test with the same data.

If number < 0, number_chosen < 0, or number < number_chosen, COMBIN returns the #NUM ! error value.

https://support.office.com/en-gb/article/combin-function-12a3f276-0a21-423a-8de6-06990aaf638a

 

[S.H.A.D.O.]

I understand that, but I want to perform the test with the same data.

If number < 0, number_chosen < 0, or number < number_chosen, COMBIN returns the #NUM ! error value.

https://support.office.com/en-gb/article/combin-function-12a3f276-0a21-423a-8de6-06990aaf638a

This is the formula with the formula replaced with the values...

=COMBIN(5,5)*COMBIN(39-5,0)*COMBIN(1,1)*COMBIN(5,1-1)

Thank you.

 

[S.H.A.D.O.]

Not to worry, I found that it didn't work because the cells were merged.

 

[DanteAmor]