software

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: www.excelforum.com/member.php...oamp;userid=11654
View this thread: www.excelforum.com/showthread...hreadid=507138
You don't even need an IF function for that

Try this in B3

=AND(A1=zzz,A2=yyy,A3=xxx)--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=507138In B3:

=AND(A1=quot;zzzquot;,A2=quot;yyyquot;,A3=quot;xxxquot;

--
Kind regards,

Niek Otten

quot;andyp161quot; gt; wrote in
message ...
gt;
gt; Is it possible to write the IF FUNCTION with more than 1 arguement e.g.
gt;
gt; If A1=zzz and A2=yyy then enter True/False in B2
gt;
gt; Or:
gt;
gt; If A1=zzz and A2=yyy and A3=xxx then enter True/False in B3
gt;
gt; Many thanks
gt;
gt; Andy
gt;
gt;
gt; --
gt; andyp161
gt; ------------------------------------------------------------------------
gt; andyp161's Profile:
gt; www.excelforum.com/member.php...oamp;userid=11654
gt; View this thread: www.excelforum.com/showthread...hreadid=507138
gt;
quot;andyp161quot; wrote:
gt; Is it possible to write the IF FUNCTION with more than 1 arguement
gt; e.g. If A1=zzz and A2=yyy then enter True/False in B2
gt; Or:
gt; If A1=zzz and A2=yyy and A3=xxx then enter True/False in B3

Just use AND(..) within the IF, something like:
=IF(AND(A1=quot;zzzquot;,A2=quot;yyyquot;),quot;Yesquot;,quot;Noquot;)
=IF(AND(A1=quot;zzzquot;,A2=quot;yyyquot;,A3=quot;xxxquot;),quot;Yesquot;,quot;Noquot;)
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
Hi

=AND(A1=quot;zzzquot;,A2=quot;yyyquot;)
=AND(A1=quot;zzzquot;,A2=quot;yyyquot;quot;,A3=quot;zzzquot;)
You have to write the passende formula into according cell (B2 or B3)--
Arvi Laanemets
( My real mail address: arvi.laanemetslt;atgt;tarkon.ee )quot;andyp161quot; gt; wrote in
message ...
gt;
gt; Is it possible to write the IF FUNCTION with more than 1 arguement e.g.
gt;
gt; If A1=zzz and A2=yyy then enter True/False in B2
gt;
gt; Or:
gt;
gt; If A1=zzz and A2=yyy and A3=xxx then enter True/False in B3
gt;
gt; Many thanks
gt;
gt; Andy
gt;
gt;
gt; --
gt; andyp161
gt; ------------------------------------------------------------------------
gt; andyp161's Profile:
gt; www.excelforum.com/member.php...oamp;userid=11654
gt; View this thread: www.excelforum.com/showthread...hreadid=507138
gt;