SOLVED
Home

Formula Help - If/OR Function

Highlighted
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
Highlighted

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

Highlighted

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

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

Related Conversations
Need some help figuring out edge://sync-internals/
HotCakeX in Discussions on
0 Replies
Notifications from Planner in Teams
nwehl in Microsoft Teams on
1 Replies
Embedded Sharepoint List - Custom Forms not loading
sbayer in Microsoft Teams on
0 Replies
SharePoint 2013 LIst Filters (by latest date)
dmphil in SharePoint on
0 Replies
Adding Wiki Tab Issue
goatscandrum in Microsoft Teams on
1 Replies