View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default What 'value' is a Dec2Bin output?

When you work with 2003 make sure to add the Add-In

If this post helps click Yes
---------------
Jacob Skaria


"EvilTony" wrote:

"Jacob Skaria" wrote:

Try

=IF(DELTA(DEC2BIN(A1),B1),"Yes","No")



Thanks.
Thanks to all of you.

As Jakob's "Delta" function is immediately and plainly explained in the Help
pages, that's the one I'll be going with.

My students would not immediately appreciate the use of "text" with a
number, nor the idea of adding something (even a zero) to a number being
checked for correspondence.

Once again, thanks.
--
It''s a little fit bunny, this feeling inside