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