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

Good morning mick2

=IF(AND(A1="yes",A2="yes",A3="yes")=TRUE,"You Passed Both Tests",0)

You need to use a combination of the If and AND function. You haven't
said which cells you are testing (or what for), so my example tests A1,
A2 and A3 are equal to "yes".

HTH

DominicB


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

Hi DominicB,

I modified your formula to suit my requirements and it works well,
thank you very much!

Kind regards,
Mick2


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

Hi Mick

No problem. Appreciate the feedback.

DominicB


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