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" wrote:

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" wrote:

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