| 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?
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 |
|
#3
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 |
|
#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 | |||
Hybrid Mode
