If Function - Multiple Arguements?

  • Thread starter Thread starter andyp161
  • Start date Start date
A

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

And
 
You don't even need an IF function for that :)

Try this in B3

=AND(A1=zzz,A2=yyy,A3=xxx)
 
andyp161 said:
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
Click to expand...

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

---
 
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)
 
Back
Top