Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 --- |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index Match function for multiple linked variables | Excel Worksheet Functions | |||
multiple results display after filter function | Excel Worksheet Functions | |||
Logical Function - Multiple IF statements | Excel Worksheet Functions | |||
SumIf Function using multiple criteria | Excel Worksheet Functions | |||
Need Function for adding rows on multiple sheets... struggling rookie ;) Thanks. | Excel Worksheet Functions |