Combining functions into same formula

[domdomw]

I'm struggling to combine two functions. I currently have the formula:

<edate(l4,3),o4<24,l4>

Which says if something meets any of these conditions then display the text "Yes" but if not then display the "No". That works absolutely fine.


However, I want to combine a formula into the same cell that says "if cell G2 contains the text 'Red' or 'Blue' also say "No"). Not sure how to combine that into the formula above. Any help would be greatly appreciated.</edate(l4,3),o4<24,l4></edate(l4,3),o4<24,l4>

 

[domdomw]

Sorry, struggling to post the formula as text:

 

[BarryL]

=IF(OR(ISNUMBER(SEARCH("Red",G2)),ISNUMBER(SEARCH("Blue",G2)),"No",IF(OR(P2>38,J2<edate(l2,3),o2<24,l2>0),"Yes","No"))

sorry your formula goes in the red part</edate(l2,3),o2<24,l2>

 

[bosco_yip]

Try,

=IF(OR(P2>38,J2< EDATE(L2,3),O2<24,L2>0)+AND(G2<>{"Red","Blue"}),"Yes","No")

Regards

 

[domdomw]

Try,

=IF(OR(P2>38,J2< EDATE(L2,3),O2<24,L2>0)+AND(G2<>{"Red","Blue"}),"Yes","No")

Regards

Perfect-thanks!