SOLVED
Home

Formula Help - If/OR Function

Kristy_Jane
New Contributor

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

Hi @Kristy_Jane 

 

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

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
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")

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
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies