You need to get them both to either numbers or text. Here's one way to turn
both into 8-character text strings to compa
=IF(TEXT(DEC2BIN(A1),"00000000")=TEXT(B1,"00000000 "),"YES","NO")


"EvilTony" wrote:

I'm trying to verify that the guess someone makes as to the binary equivalent
of a decimal number is correct.

Example

cell A1 holds, say, 8

User must enter their 'estimate' of the binary value of 8 in cell B1

cell C1 formula: =IF(DEC2BIN(A1)=B1,"Yes","No")

I cannot get this to return a "Yes" when B1 = 1000

----

Strangely, what does work is if I use the 'reverse'
cell c1 formula: =IF(BIN2DEC(B1)=A1,"Yes","No")

Why doesn't Excel 'see' an entry of 1000 as being the same as an putput of
1000 from Dec2Bin?


--
It''s a little fit bunny, this feeling inside