If

M

mick2

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 alway
get the ubiquitous *TRUE* message.

My formula, is:

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

Regards,
Mick
 
D

dominicb

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'
said which cells you are testing (or what for), so my example tests A1
A2 and A3 are equal to "yes".

HTH

Dominic
 
M

mick2

Hi DominicB,

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

Kind regards,
Mick2
 
Top