Report a bug
OS version: Windows 10 Pro
App version: 7.1.1.57
Downloaded from: ONLYOFFICE website

The COMBIN function in spreadsheet editor is malfunctioning because:
COMBIN(0, 0) = COMBIN(n, 0) = 1, not #NUM!
and COMBIN(n, k) = 0, if k > n, not #NUM!

I don’t understand why it’s good for you guys to implement a math function incorrectly, not a spreadsheet function?
If you don’t copy the bugs, yours can only be better. Only in this case the function has a value of 0.
Now you have to write this in every editor to make the Combin function work as it should:
=IF(n>k, combin(n,k), 0)

I’d like to inform you that we have registered your suggestion to make COMBIN function to result in 0 when second argument is bigger than the first one. Unfortunately, I cannot provide any approximate dates on when this suggestion would be implemented.

I have to inform you that suggestion to make COMBIN function to result in 0 when second argument is bigger than the first one, unfortunately, cannot be implemented. Besides the fact that #NUM! is the expected result in most popular editors, also because it breaks compatibility with other editors due to change of the calculation scheme of the function.

We appreciate your interest to the editors and thank you for your suggestion/report.