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
|