View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
EvilTony EvilTony is offline
external usenet poster
 
Posts: 9
Default What 'value' is a Dec2Bin output?

"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