Combining functions into same formula

domdomw

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

<edate(l4,3),o4<24,l4>
PHP:
``````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>``````

Excel Facts

Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

domdomw

New Member
Sorry, struggling to post the formula as text:

BarryL

Well-known Member
=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>

Last edited:

bosco_yip

Well-known Member
Try,

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

Regards

Last edited:

domdomw

New Member
Try,

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

Regards

Perfect-thanks!

Replies
7
Views
1K
Replies
5
Views
484
Replies
7
Views
1K
Replies
12
Views
3K
Replies
19
Views
380

1,191,310
Messages
5,985,915
Members
439,987
Latest member
g00ber

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back