In B3:

=AND(A1="zzz",A2="yyy",A3="xxx"

--
Kind regards,

Niek Otten

"andyp161" wrote in
message ...

Is it possible to write the IF FUNCTION with more than 1 arguement e.g.

If A1=zzz and A2=yyy then enter True/False in B2

Or:

If A1=zzz and A2=yyy and A3=xxx then enter True/False in B3

Many thanks

Andy


--
andyp161
------------------------------------------------------------------------
andyp161's Profile:
http://www.excelforum.com/member.php...o&userid=11654
View this thread: http://www.excelforum.com/showthread...hreadid=507138