View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jason Jason is offline
external usenet poster
 
Posts: 367
Default IF/OR Logic Function

does one or the other have to take precedence or can they be equal

"T. Valko" wrote:

=IF(M8="1st Monday",I8,"")
=IF(K14="15th",I14,"")


Which of those should have precedence?

Take your pick:

=IF(M8="1st Monday",I8,IF(K14="15th",I14,""))

=IF(K14="15th",I14,IF(M8="1st Monday",I8,""))


--
Biff
Microsoft Excel MVP


"Jason" wrote in message
...
I cannot figure out how to nest a logic funtion.

I have =IF(M8="1st Monday",I8,"")

I would like to nest =IF(K14="15th",I14,"")

in the same cell.

Thanks for the help

Jason