Formula Help - If/OR Function

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?


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





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

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

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