Hi,

I am trying to use the *IF* function to display *You Passed Both Tests*
when the values in 3 cells are identical (which they are) but I always
get the ubiquitous *TRUE* message.

My formula, is:

::=IF(F48,E56=C1,\"You Passed Both Tests\")::

Regards,
Mick.


--
mick2
------------------------------------------------------------------------
mick2's Profile: http://www.excelforum.com/member.php...o&userid=24143
View this thread: http://www.excelforum.com/showthread...hreadid=472523