If Function - Multiple Arguements?
 

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

If Function - Multiple Arguements?
 

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: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=507138

If Function - Multiple Arguements?
 

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

If Function - Multiple Arguements?
 

"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
---

If Function - Multiple Arguements?
 

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<attarkon.ee )


"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