Thread: Combining IF OR and AND functions
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
andyp161
 
Posts: n/a
Default 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

Reply With QuoteReply With Quote