• 411K Members
• 5,889 Online
• 466K Conversations
SOLVED

New Contributor

Formula Help - If/OR Function

I'm trying to write a formula that will prompt review based on certain criteria in a list.  The only "true" return values I'm getting are on the argument with a greater than numberic value.  Is there another/better way when 2 of the arguments are text values?

=IFERROR(IF(OR(A246=Rules!B:B,Q246=Rules!A:A,N246<35),"","Review"),"Review")

4 Replies

Re: Formula Help - If/OR Function

Could you post a sample file to show what you are trying to do ?

I'm a bit confused by the A246=Rules!B:B,Q246=Rules!A:A  part

Thanks

Wyn

Re: Formula Help - If/OR Function

I'll try to get a sample file uploaded.  Rules!A;A and Rules!B:B is referencing a range on another worksheet, same workbook.  So if Q2 equals any value in the range in Column B on Rules tab, value should return "".

Solution

Re: Formula Help - If/OR Function

Ah ok, you'll need to do a COUNTIFS. So something like this

=IFERROR(IF(OR( COUNTIFS( Rules!B:B,A246)>0,
COUNTIFS( Rules!A:A,Q246)>0, N246<35),"","Review"),"Review")

Re: Formula Help - If/OR Function

This worked perfectly!  I tried similar, but I must have been missing a piece of the argument.  thanks! @Wyn Hopkins

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies