| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining IF OR and AND functions
Hi There, Is it possible to combine IF OR AND functions? I can combine IF with AND and IF with OR but not all three. E.g. Is it possible to put the following into a formula: 'IF A2 AND A3 = A1 OR A4 AND A5 = A1 return yes Hope you can help. Many thanks -- andyp161 ------------------------------------------------------------------------ andyp161's Profile: http://www.excelforum.com/member.php...o&userid=11654 View this thread: http://www.excelforum.com/showthread...hreadid=534558 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Combining IF OR and AND functions
Try:
=IF(OR(AND(A2=A1,A3=A1),AND(A4=A1,A5=A1)),"Yes","N o") "andyp161" wrote: Hi There, Is it possible to combine IF OR AND functions? I can combine IF with AND and IF with OR but not all three. E.g. Is it possible to put the following into a formula: 'IF A2 AND A3 = A1 OR A4 AND A5 = A1 return yes Hope you can help. Many thanks -- andyp161 ------------------------------------------------------------------------ andyp161's Profile: http://www.excelforum.com/member.php...o&userid=11654 View this thread: http://www.excelforum.com/showthread...hreadid=534558 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Combining IF OR and AND functions
Thank you - this works great. I am also trying to make the following work, without much success - can you help? =IF((I5="Executive Consultant"),I5),OR(AND($A7=$A5,$I7="Executive Consultant"),$I7) e.g. IF I5 = "Executive Consultant" then return I5, OR if A7 = A5 AND I7 = "Executive Consultant" return I7. Many thanks -- andyp161 ------------------------------------------------------------------------ andyp161's Profile: http://www.excelforum.com/member.php...o&userid=11654 View this thread: http://www.excelforum.com/showthread...hreadid=534558 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Combining IF OR and AND functions
Try:
=IF(I5="Executive Consultant",I5,IF(AND($A7=$A5,$I7="Executive Consultant"),$I7,"")) "andyp161" wrote: Thank you - this works great. I am also trying to make the following work, without much success - can you help? =IF((I5="Executive Consultant"),I5),OR(AND($A7=$A5,$I7="Executive Consultant"),$I7) e.g. IF I5 = "Executive Consultant" then return I5, OR if A7 = A5 AND I7 = "Executive Consultant" return I7. Many thanks -- andyp161 ------------------------------------------------------------------------ andyp161's Profile: http://www.excelforum.com/member.php...o&userid=11654 View this thread: http://www.excelforum.com/showthread...hreadid=534558 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
