If Function - Multiple Arguements?

[andyp161]

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

[daddylonglegs]

You don't even need an IF function for that

Try this in B3

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

[Niek Otten]

In B3:

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

--
Kind regards,

Niek Otten

"andyp161" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Max]

"andyp161" wrote:
> 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

Just use AND(..) within the IF, something like:
=IF(AND(A1="zzz",A2="yyy"),"Yes","No")
=IF(AND(A1="zzz",A2="yyy",A3="xxx"),"Yes","No")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

[Arvi Laanemets]

Hi

=AND(A1="zzz",A2="yyy")
=AND(A1="zzz",A2="yyy"",A3="zzz")
You have to write the passende formula into according cell (B2 or B3)


--
Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )


"andyp161" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>