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

Do you want the first IF to take precedence over the second IF? You could try:

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

Or do you want both cells to display if both are true? Then try:

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

If neither of these are what you're looking for, then perhaps provide more
info on what you want and maybe include some sample data.

HTH
Elkar



"Jason" wrote:

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