S.H.A.D.O.
Well-known Member
- Joined
- Sep 6, 2005
- Messages
- 1,915
You could put the values you have in each cell L4, C14, L5, L6, E14
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
=COMBIN(5,5)*COMBIN(39-5,0)*COMBIN(1,1)*COMBIN(5,1-1)