IF/OR Logic Function

[Jason]

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

 

[Don Guillett]

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

 

[Elkar]

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

 

[T. Valko]

=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,""))

 

[Jason]

I am setting up a budget. I need two types of data to insert into the same
cell. The two questions are when does a paycheck post.
The first option is "1st Monday" of the month: =IF(M9="1st Monday",I9,"")
The second option is the "5th" being a date: =IF(K14="5th",I14,"")

So I need to be able to populate the same cell if both formulas are true
with the sum of both entries. And also to populate the cell if one is false
and another true and vice versa.

Thanks Jason

 

[Elkar]

Ok, see if this works:

=IF(AND(M9="1st Monday",K14="5th"),I9+I14,IF(M9="1st
Monday",I9,IF(K14="5th",I14,"")))

HTH
Elkar

 

[Jason]

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

 

[T. Valko]

Ok, after reading your follow-up to Elkar, this will do what you want:

=(M9="1st Monday")*I9+(K14="5th")*I14