# formula for binary to decimial not working right

#### richsark

##### Board Regular
Hello All, I honestly forget who helped me with this back in Dec 08, I tried to look for my thread, but I cant find it.

Anyway, this formula was working great since 12-08, but someone came to me yesterday saying there is a flaw in the formula between Company A and Company B

If you note that 10.125.239.0/24 is overlapped with 10.125.236.0/22, yet is marked FALSE
FindDuplicateIPRanges12-26-08-v7-Sorted.xls
ABCDEFGHIJKLM
7221CompanyA10.125.236.0255.255.252.0371148121760245761023176025599TRUE
7222CompanyA10.125.237.0255.255.255.037114812176024832255176025087TRUE
7223CompanyA10.125.239.0255.255.255.037114812176025344255176025599FALSE
7224CompanyB10.125.240.0255.255.255.037114812176025600255176025855TRUE
7225CompanyB10.125.240.0255.255.255.252371148121760256003176025603TRUE

Can someone please look at the formula to see where the calculation is flawed.

Thanks

### Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

#### richsark

##### Board Regular
Hello Bill,

Its not this one. It originally started with this. As I recall the formula did not work the way I wanted it.

Then someone else wrote a new logic.( I think, meaning I dont know if it was the same user)

Is there a way to find out why its not working right? and or why did it mark it as "False"

Thanks

#### Bill_Biggs

##### Well-known Member
Look at it this way:

Excel Workbook
EFGHIJKLM
7216For Equation to be TrueL7223>J7224ORJ7223L7222*
7217Actual176025599176025600FALSE176025344>176025087FALSE
Sheet1

It is supposed to be false in this circumstance. Both halves of the equation are false in this case, making for a false. Does that make sense? It just now dawned on me.

#### richsark

##### Board Regular
Right, the calculation is off. according to the way subnets/networks work, that should be considered duplicate that

10.125.239.0/24 is overlapped with 10.125.236.0/22

I need the Equation fixed to justify this senerio

#### richsark

##### Board Regular

http://www.subnet-calculator.com/subnet.php?net_class=A

and Enter 10.125.236.0

You can see that the hosts per subnet is 1022
Available networks are 10.125.236.1 - 10.125.239.254

It clearly shows that it overlaps

On the spreadsheet Column K shows 1023, I think the calculation is off by a bit

Last edited:

#### Bill_Biggs

##### Well-known Member
My apologies, I did not dig deeply enough to understand the extent of the problem. I'll dig a little deeper this afternoon and see if I can help.

#### richsark

##### Board Regular
Great !

Look forward in solving this mystery !

#### richsark

##### Board Regular
Hi Bill, any clues?

Anyone else have an idea?

#### Bill_Biggs

##### Well-known Member
Sent you a private message.

Replies
6
Views
670

1,191,577
Messages
5,987,399
Members
440,096
Latest member
yanaungmyint

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back