Combining two seperate IF statemens which include OR and AND functions

[James Winter]

Dear All,

I require your assistance,

I am using Excel 2010 and have created two formulas to go into two seperate cells.

In cell K4 : =IF(AND(D4="Friday",E4>C4),J4-2,J4)

and

In Cell L5: =IF(AND(D4="Thursday",(OR(K4=4,K4=5))),K4-2,K4)

I want to both of these formulas into one cell so I have all the date in one column rather then two.

Hope someone can help.

Thanks!

Winter

 

[steve the fish]

Hi. Its not possible as you have it there no. Lets take first equation, if D4 is not Friday then the result is whatever is in J4. So its possible, when looking at the 2nd equation, that if D4 is Thursday (ignoring the other parts of the and equation) that you have the result as J4 (from first equation) and K4-2 (from 2nd equation). There cant be 2 TRUE results.

 

[steve the fish]

Ignore me. Im talking rubbish. Just looked where the formulas were housed. One sec!

 

[steve the fish]

Check this works ok for you:

=IF(AND(D4="Thursday",OR(J4=4,J4=5)),J4-2,IF(AND(D4="Friday",E4>C4),J4-2,J4))

 

[James Winter]

Mate appreciate it.

I think that is perfect. Testing seems to show it gives me the correct results.

Thanks Again!!