# My formula gives the wrong answer.

1. ## My formula gives the wrong answer.

If I calculate combin(25, 10) in a cell I get the right answer, which is 3,268,760, and if I type that number directly into the isodd function, I get the right answer as well. So why is it that when I put isodd(combin(25, 10)) into a cell, I get the wrong answer?

2. ## Re: My formula gives the wrong answer.

MCweb welcome to the forum.

Good question. I get the same, and I have never encountered this before.

I'll pass this on to the community.

3. ## Re: My formula gives the wrong answer.

Is it a bug in Excel? I don't have Excel to test on here, but I note that both LibreOffice Calc and Gnumeric return FALSE for this particular example.

4. ## Re: My formula gives the wrong answer.

I just tried

=MOD(COMBIN(25,10),1)

It returns 0.999999999534338

So does

=MOD(FACT(25)/FACT(15)/FACT(10),1)

Appears to be a floating point issue.

5. ## Re: My formula gives the wrong answer.

A quick search of the net (search string, "Excel COMBIN function floating point") turned these up. Apparently you are not alone.

https://www.excelbanter.com/excel-wo...-integers.html

https://www.excelbanter.com/excel-wo...ntegers-2.html

https://www.excelforum.com/excel-for...bug-print.html

6. ## Re: My formula gives the wrong answer.

Originally Posted by MrShorty
Is it a bug in Excel? I don't have Excel to test on here, but I note that both LibreOffice Calc and Gnumeric return FALSE for this particular example.
My search found in LibreOffice this is not a bug.

7. ## Re: My formula gives the wrong answer.

So to get rid of it, you'd need
Formula:
`Please Login or Register  to view this content.`

8. ## Re: My formula gives the wrong answer.

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1