Jacob,,

And the reason I suggested it instead of DELTA is because I have some
difficulty with DELTA because of what I see as inconsistencies. Consider this

A1 to A3 hold the values 2.1, 2.3, 2.4
B1 to b3 hold the values 2.1, 2.4, 2.3

=SUM(A1:A3)=SUM(B1:B3) - Evaluates as we might expect as TRUE

but
=DELTA(SUM(A1:A3),SUM(B1:B3))=1 - Evaluates as FALSE so DELTA doesn't
recognise the 2 sums as equal.

Mike


"Jacob Skaria" wrote:

Totally agree with Mike.. Multiplication by 1/Addition of 0 is a commonly
used by programmers in most scripting languages for type casting.

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


"Mike H" wrote:

Hi,

I agree Jacob's solution is very good but multiplication by 1 or the
addition of zero is a commonly used technique in Excel for converting text to
numbers.

If you read Excel help again for Delta I think you still have some
explaining to do to your students. For example

A1=8
A2 =DEC2BIN(A1)
A3 =isnumber(A2) evaluates as FALSE
A4 = istext(A2) evaluates as TRUE

So we have established that DEC2BIN returns text and if we now turn to Excel
help

Remarks

If number1 is nonnumeric, DELTA returns the #VALUE! error value.
If number2 is nonnumeric, DELTA returns the #VALUE! error value.

Yet delta works!! Not very intuative for your students.

Mike

"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